Re: Why is checkpoint so costly?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is checkpoint so costly?
Дата
Msg-id 17436.1119388599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why is checkpoint so costly?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Can we break down everything that happens during a checkpoint so that we 
> can see where this huge cost is coming from?     Checkpointing should be 
> limited to fsyncing to disk and marking WAL files as recyclable, but there 
> seems to be something more.

I already asked you to measure the thing I think is the likely candidate
(to wit, dumping full page images into WAL).
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: pg_terminate_backend idea