Re: Question regarding performance (large objects involved)

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: u15074 <u15074(at)hs-harz(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question regarding performance (large objects involved)
Date: 2003-06-26 08:06:59
Message-ID: 3EFAA9A3.9000707@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Jury 2003-06-26 09:31:11 FW: INSERT WHERE NOT EXISTS
Previous Message Shridhar Daithankar 2003-06-26 07:49:09 Re: How many fields in a table are too many