Re: Plans for solving the VACUUM problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Plans for solving the VACUUM problem
Дата
Msg-id 13940.990163746@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Plans for solving the VACUUM problem  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Another quick thought for handling FSM contention problems.  A backend could
> give up waiting for access to the FSM after a short period of time, and just
> append it's data to the end of the file the same way it's done now.  Dunno
> if that is feasable but it seemed like an idea to me.

Mmm ... maybe, but I doubt it'd help much.  Appending a page to the file
requires grabbing some kind of lock anyway (since you can't have two
backends doing it at the same instant).  With any luck, that locking can
be merged with the locking involved in accessing the FSM.
        regards, tom lane


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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Plans for solving the VACUUM problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Plans for solving the VACUUM problem