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$50824e40@iboats.com (view raw or flat)
Thread:
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
columns.

   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. : )

steve



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-2014 The PostgreSQL Global Development Group