AW: Vacuum only with 20% old tuples

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Vacuum only with 20% old tuples
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368028@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> OK,I see. Your idea seems to be close to Vadim's *relink*. 
> However it isn't clear if *relink* has no problem.
> In my test case on cygwin port ,*relink* doesn't work well.
> *relink* caused an error if concurrent backends open the
> *relink*ing table.

All actions involving a rename of a file imho involve exclusive access 
to the table, thus no concurrent access is allowed/possible.

Andreas


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

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Vacuum only with 20% old tuples
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: AW: Vacuum only with 20% old tuples