Re: Poor performance when deleting from entity-attribute-value type master-table

On 02/09/2015 01:12 PM, Andreas Joseph Krogh wrote:
> Are there any ways around this or do people simply avoid having FKs in
> schemas like this?

Don't use EAV.  It's a bad design pattern, especially for you, and
you've just discovered one of the reasons why.

(In fact, I am just today dismantling an EAV database and normalizing
it, and so far application throughput is up 500%)

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com