Re: Question regarding performance (large objects involved) - Mailing list pgsql-general

From Tom Lane
Subject Re: Question regarding performance (large objects involved)
Date
Msg-id 23851.1056635148@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question regarding performance (large objects involved)  (Mark Kirkwood <markir@paradise.net.nz>)
List 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 by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: How many fields in a table are too many
Next
From: Richard Huxton
Date:
Subject: Re: Foreign keys