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

From Florent Guillaume
Subject Re: Re: is PG able to handle a >500 GB Database?
Date
Msg-id 20010122235121.A20293@twin.efge.org
Whole thread Raw
In response to Re: Re: is PG able to handle a >500 GB Database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > 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 ...

Yes, I meant insert there, sorry for being confusing.

Florent

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: is PG able to handle a >500 GB Database?
Next
From: Bruce Momjian
Date:
Subject: Re: Re: is PG able to handle a >500 GB Database?