Re: Re: is PG able to handle a >500 GB Database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florent Guillaume <efgeor(at)noos(dot)fr>
Cc: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: is PG able to handle a >500 GB Database?
Date: 2001-01-22 22:35:14
Message-ID: 14352.980202914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Florent Guillaume <efgeor(at)noos(dot)fr> writes:
> If, however, like someone else on this list, you have an application
> that does 200 requests per second, and that each request generates two
> updates, that's 1440000 oids consumed per hour, 34560000 per day,
> 12614400000 per year, oops that's more than 2^32, oids have wrapped
> around nearly three times in the year...

Updates do not consume OIDs ... only insertions of *new* rows consume
OIDs ... that may or may not matter here ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florent Guillaume 2001-01-22 22:51:21 Re: Re: is PG able to handle a >500 GB Database?
Previous Message Tom Lane 2001-01-22 22:11:33 Re: optimizing "between" queries