Re: OID wraparound: summary and proposal - Mailing list pgsql-hackers

From Tom Lane
Subject Re: OID wraparound: summary and proposal
Date
Msg-id 1894.997288754@sss.pgh.pa.us
Whole thread Raw
In response to Re: OID wraparound: summary and proposal  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: OID wraparound: summary and proposal
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Also I am worried about the performance of the per table Oid
> generators.

I think performance would be a big problem if we tried to implement them
just like sequences are done now.  But a shared hashtable of Oid
generators (each one handled roughly like the single Oid generator
currently is) would probably work okay.  We'd have to work out how to
have a backing disk table for this hashtable, since we couldn't expect
to have room in shared memory for all generators at all times --- but we
could cache all the active generators in shared memory, I'd think.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CURRENT OF cursor without OIDs
Next
From: mlw
Date:
Subject: Re: OID wraparound: summary and proposal