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

> Florent Guillaume <efgeor@noos.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 ...

What about pre-fetching of OID's.  Does that still happen for every
backend?  What about XID's?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026