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)
Список
Дерево обсуждения
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 по дате отправления