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
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
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
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)
-