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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-01-22 22:57:32 Re: Re: is PG able to handle a >500 GB Database?
Previous Message Tom Lane 2001-01-22 22:35:14 Re: Re: is PG able to handle a >500 GB Database?