Re: [HACKERS] WAL logging freezing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] WAL logging freezing
Дата
Msg-id 8993.1162329918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] WAL logging freezing  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Huh, but the log would not be flushed for each operation that the vacuum
> logs.  Only when it's going to commit.

It strikes me that the vacuum cost delay feature omits to consider
generation of WAL records as a cost factor.  It may not be a big problem
though, as long as we can limit the number of records created to one or
two per page --- then you can see it as just a component of the "dirtied
a page" cost.  If we made a separate WAL record for each tuple then it
could be important to account for.

            regards, tom lane

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

Предыдущее
От: Marc Munro
Дата:
Сообщение: Shared Memory Hooks Documentation (was Re: New shared memory hooks proposal)
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: [HACKERS] WAL logging freezing