Rod Taylor writes:
> Someones bound to hit it in a year or 2 as Postgres is getting pretty
> good for large projects as well as the small, especially with 7.1's
> speed enhancements. Hopefully 7.2 will create cycling OIDs and XIDs.
> Then less problems in 'unlimited' extendability.
The easiest approach for OIDs will probably be making them optional in the
first place. For the vast majority of users, the OIDs are just wasting
space.
The cycling XID idea is based on the assertion that eventually all
transactions will be closed, at which time a record is either known
committed or known dead so that the XID can be recycled. For OIDs, this
is not practical. And if you wanted OIDs that automatically fill in the
holes, that's probably not realistic.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/