Re: Re: AW: Re: OID wraparound: summary and proposal

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Re: AW: Re: OID wraparound: summary and proposal
Дата
Msg-id 3B6F6B15.7B423C15@tm.ee
обсуждение исходный текст
Ответ на RE: Re: AW: Re: OID wraparound: summary and proposal  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы Re: Re: AW: Re: OID wraparound: summary and proposal  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> mlw <markw@mohawksoft.com> writes:
> > Am I being overly simplistic?
> 
> Yes.  For one thing, Relation structs are *not* shared, nor even
> persistent (the relcache will happily discard them). 

Will it be easier to make Relation shared and persistent or creating 
a new shared structure that has just a counter+lock for each 
relation oid ?

> For another, you
> haven't mentioned how we keep the counter up-to-date across system
> restarts.

Perhaps write it to database at checkpoints and get the last INSERTED
record 
from WAL at restart ? 

Probably too simplistic as well ;)


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: OID wraparound: summary and proposal
Следующее
От: Matthew Kirkwood
Дата:
Сообщение: Re: Notes about int8 sequences