| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Florent Guillaume <efgeor(at)noos(dot)fr>, "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:57:32 |
| Message-ID: | 200101222257.RAA15517@candle.pha.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 ...
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-22 23:05:37 | OID/XID allocation (was Re: is PG able to handle a >500 GB Database?) |
| Previous Message | Florent Guillaume | 2001-01-22 22:51:21 | Re: Re: is PG able to handle a >500 GB Database? |