> > 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
- [GENERAL] Re: is PG able to handle a >500 GB Database... Florent Guillaume
- [GENERAL] Re: is PG able to handle a >500 GB Dat... Florent Guillaume
- [GENERAL] Re: is PG able to handle a >500 GB... Martin A. Marques
- [GENERAL] Re: is PG able to handle a >50... Florent Guillaume
- [GENERAL] Re: is PG able to handle a &g... Martin A. Marques
- [GENERAL] Re: is PG able to handle... Florent Guillaume
- Re: [GENERAL] Re: is PG able t... Tom Lane
- Re: [GENERAL] Re: is PG ab... Florent Guillaume
- Re: [GENERAL] Re: is PG ab... Bruce Momjian
- [GENERAL] OID/XID allocati... Tom Lane
- [GENERAL] Re: OID/XID allo... Bruce Momjian
- Re: [GENERAL] OID/XID allo... Bruce Momjian