> What PG version are you using?
> IIRC, in pre-7.1 code, backends allocate OIDs in blocks of 32 (?? more
> or less anyway); so if a backend uses one OID and then exits, you wasted
> 31 OIDs. This does not happen anymore with 7.1, though.
> Another possibility is that you're creating lots of temp tables --- each
> one will cost you a dozen or so OIDs, depending on the number of
Thanks, Tom. We are using 7.0.x, and they do appear to be used in
chunks of 32. One more reason for me to upgrade. : )
In response to
pgsql-general by date
|Next:||From: HYip||Date: 2001-05-30 21:33:22|
|Subject: timeout for a transaction|
|Previous:||From: Tom Lane||Date: 2001-05-30 21:20:19|
|Subject: Re: OID's.... |