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

From Mark Kirkwood
Subject Re: Question regarding performance (large objects involved)
Date
Msg-id 3EFAA9A3.9000707@paradise.net.nz
Whole thread Raw
In response to Question regarding performance (large objects involved)  (u15074 <u15074@hs-harz.de>)
Responses Re: Question regarding performance (large objects involved)
List pgsql-general
Could be the the database is checkpointing then. Try experimenting with :

checkpoint_segments
checkpoint_timeout

Might be worth playing with :

wal_buffers

as well

regards

Mark

u15074 wrote:

>The performance is ok and stays constant over the whole time. But I have the
>following effect: from time to time a short interruption occurs (my test program
>is standing still for a moment) and then it goes on.
>Has anyone an idea what might cause these pauses? Is it due to caching
>mechanisms of the database?
>
>



pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: How many fields in a table are too many
Next
From: Benjamin Jury
Date:
Subject: FW: INSERT WHERE NOT EXISTS