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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance