Re: Question regarding performance (large objects involved)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question regarding performance (large objects involved)
Дата
Msg-id 23851.1056635148@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Question regarding performance (large objects involved)  (Mark Kirkwood <markir@paradise.net.nz>)
Список pgsql-general
Mark Kirkwood <markir@paradise.net.nz> writes:
> Could be the the database is checkpointing then.

Or the system 'syncer' process woke up and wrote a bunch of pages.
If the interval between pauses doesn't vary when you change
checkpoint_timeout and checkpoint_segments, then I'd blame the syncer
(or possibly some other external activity).

            regards, tom lane

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

Предыдущее
От: Jonathan Bartlett
Дата:
Сообщение: Re: How many fields in a table are too many
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Foreign keys