Re: CLOG extension

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: CLOG extension
Дата
Msg-id CA+TgmobS+PzLa+oq3simwakSeJJxtH3Nerh-RdViy0qcgrdHaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CLOG extension  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, May 3, 2012 at 2:50 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Doing it a background process, though, may make sense.  What I'm a
> little worried about is that - on a busy system - we've only got about
> 2 seconds to complete each CLOG extension, and we must do an fsync in
> order to get there.

Scratch that - we don't routinely need to do an fsync, though we can
end up backed up behind one if wal_buffers are full.  I'm still more
interested in the do-it-a-page-in-advance idea discussed upthread, but
this might be viable as well.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Temporary tables under hot standby
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: CLOG extension