table size/record limit - Mailing list pgsql-general

From Dennis Gearon
Subject table size/record limit
Date
Msg-id 4176F503.3060305@fireserve.net
Whole thread Raw
Responses Re: table size/record limit  (Tino Wildenhain <tino@wildenhain.de>)
Re: table size/record limit  (David Helgason <david@uti.is>)
Re: table size/record limit  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
I am designing something that may be the size of yahoo, google, ebay, etc.

Just ONE many to many table could possibly have the following
characteristics:

    3,600,000,000 records
    each record is 9 fields of INT4/DATE

Other tables will have about 5 million records of about the same size.

There are lots of scenarios here to lessson this.

BUT, is postgres on linux, maybe necessarily a 64 bit system, cabable of
this? And there'd be 4-5 indexes on that table.

pgsql-general by date:

Previous
From: Josh Close
Date:
Subject: Re: how much ram do i give postgres?
Next
From: Neil Conway
Date:
Subject: Re: CREATE TEMPORARY TABLE AS ... ON COMMIT?