Postgres Pro
Downloads
Home   >   mailing lists

Re: is PG able to handle a >500 GB Database? - Mailing list pgsql-general

From Tom Lane
Subject Re: is PG able to handle a >500 GB Database?
Date
Msg-id 6453.979872599@sss.pgh.pa.us
Whole thread Raw
In response to is PG able to handle a >500 GB Database?  (Alvar Freude <alvar.freude@merz-akademie.de>)
List pgsql-general
Tree view 
Alvar Freude <alvar.freude@merz-akademie.de> writes:
> I guess, that there are about 100 million to 1000 million table entries

You'd probably find the OID counter wrapping around before too long.
However, as long as you don't assume that OIDs are unique in your data
tables, that shouldn't bother you a whole lot.  AFAIK you should be
able to make it work.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvar Freude
Date:
Subject: is PG able to handle a >500 GB Database?
Next
From: Alvar Freude
Date:
Subject: Re: is PG able to handle a >500 GB Database?