Very large table...

From: Jeffery Collins <collins(at)onyx-technologies(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Very large table...
Date: 2000-06-14 19:51:07
Message-ID: 3947E22B.29064352@onyx-technologies.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone have any experience with very large postgresql tables? By
very large, I mean a table with ~38 million records, each record will
have between 80 and 128 bytes (we are not sure of some column sizes yet)
in ~10 columns with probably 3 btree-indexes. Basically the table will
hold all of the Postal Service deliverable addresses in the US in a
somewhat compressed form.

My concerns are in the area of performance and robustness.

I know I haven't been specific enough about the table layout, but I am
not sure yet exactly what it will look like. I am just try to get a gut
level feeling that this has been done before and there are no "got'chas"
out there.

Thank you all,
Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-06-14 21:48:16 "Tuple is too big"
Previous Message Ron Peterson 2000-06-14 19:49:51 Re: Dropping tables