Bruce, Tom, etc.: > > This is what I mean. Does the DB engine only recycle > > *unused* OIDs (that is, does it check for teh continued > > existance of a tuple with OID 198401)? If that's the > > method, then there isn't really a problem even if I do > use > > OIDs as a primary index. None of my OIDs still in use > will > > be touched. > > > No, it uses all oids, and can create duplicates. Does this mean that Tom's "Wraparound Ragnarok" is the accurate scenario? -Josh Berkus
- Re: [SQL] OID Perfomance - Object-Relational datab... Tom Lane
- Re: [SQL] OID Perfomance - Object-Relational d... Josh Berkus
- Re: [SQL] OID Perfomance - Object-Relation... Bruce Momjian
- [SQL] Re: OID Perfomance - Object-Relational databases Jeff MacDonald
- RE: [SQL] OID Perfomance - Object-Relational databases Michael Ansley
- Re: [SQL] OID Perfomance - Object-Relational databases Mitch Vincent
- RE: [SQL] OID Perfomance - Object-Relational databases Michael Ansley
- RE: [SQL] OID Perfomance - Object-Relational databases Michael Ansley
- RE: [SQL] OID Perfomance - Object-Relational databases Michael Ansley
- Re: [SQL] OID Perfomance - Object-Relational databases Josh Berkus
- Re: [SQL] OID Perfomance - Object-Relational databases Josh Berkus
- Re: [SQL] OID Perfomance - Object-Relational databases Bruce Momjian
- Re: [SQL] OID Perfomance - Object-Relational databases Josh Berkus
- Re: [SQL] OID Perfomance - Object-Relational datab... Bruce Momjian