Re: Question regarding performance (large objects involved)

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Question regarding performance (large objects involved)
Дата
Msg-id
23851.1056635148@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Question regarding performance (large objects involved) u15074 <u15074@hs-harz.de>
Re: Question regarding performance (large objects involved) Mark Kirkwood <markir@paradise.net.nz>
Re: Question regarding performance (large objects involved) Tom Lane <tgl@sss.pgh.pa.us>
Re: Question regarding performance (large objects involved) Peter Childs <blue.dragon@blueyonder.co.uk>
Re: Question regarding performance (large objects involved) Bruno Wolff III <bruno@wolff.to>
Mark Kirkwood  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
Дата:
От: Richard Huxton
Дата:
Сообщение: Re: Foreign keys
FAQ