Re: Re: Thought on OIDs
От | Peter Eisentraut |
---|---|
Тема | Re: Re: Thought on OIDs |
Дата | |
Msg-id | Pine.LNX.4.30.0103021727350.775-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: Re: Thought on OIDs ("Rod Taylor" <rod.taylor@inquent.com>) |
Ответы |
Re: Re: Thought on OIDs
|
Список | pgsql-general |
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/
В списке pgsql-general по дате отправления: