[GENERAL] Hardware question

2015-06-30 Thread Leonard Boyce
Hoping to tap into the hive mind here. I'm looking to upgrade drives on some of our db servers and am hoping someone has run/tested a similar setup in the past and can share their wisdom. I have a pair of Dell R910s with H700 controllers and am looking to replace the existing drives with SSDs. Ri

[GENERAL] composite foreign key performance

2014-01-22 Thread Leonard Boyce
Hoping I can get some advice here. We have an existing schema as follows; lookup (id bytea PK, status text, .) data -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] composite foreign key performance

2014-01-22 Thread Leonard Boyce
Apologies for the previous partial post, fat-fingered today. I currently have; - lookup table (lookup_id BYTEA PK, status TEXT, last_update TSTAMPTZ, ...) (PK index is > 20GB) - data table (data_id BIGINT PK, customer_id BIGINT, lookup_id BYTEA, ...) which is partitioned by customer_id (there is

[GENERAL] Composite Foreign Key performance

2014-01-22 Thread Leonard Boyce
Apologies for the previous partial post earlier, fat-fingered today. If this is a repost I apologize in advance as I could not see my reply in the archive after a couple of hours. I currently have; - lookup table (lookup_id BYTEA PK, status TEXT, last_update TSTAMPTZ, ...) (PK index is > 20GB) -