Skip site navigation (1) Skip section navigation (2)

Re: OID's....

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: OID's....
Date: 2001-05-30 21:31:21
Message-ID: 002301c0e94f$dfc39940$ (view raw, whole thread or download thread mbox)
Lists: pgsql-general
> 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: HYipDate: 2001-05-30 21:33:22
Subject: timeout for a transaction
Previous:From: Tom LaneDate: 2001-05-30 21:20:19
Subject: Re: OID's....

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group