[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Poor performance when deleting from entity-attribute-value type master-table
From:       Josh Berkus <josh () agliodbs ! com>
Date:       2015-02-09 22:04:38
Message-ID: 54D92EF6.3080409 () agliodbs ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]