Re: simple update queries take a long time - postgres 8.3.1

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: mark <markkicks(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: simple update queries take a long time - postgres 8.3.1
Date: 2008-04-01 08:48:07
Message-ID: 47F1F6C7.2090607@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2008-04-01 09:44, mark wrote:

> I already am running 8.3.1 [ i mentioned in subject].

Missed that, sorry.

I'd first try to set the following on a write-busy 8.3 server to smooth
checkpoint spikes:
checkpoint_segments = 16
checkpoint_timeout = 20min
checkpoint_completion_target = 0.8

I'd also set
log_checkpoints=on
to get an idea how it behaves.

But I have no experience on anything with more than 1GB of RAM...

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-04-01 08:57:17 HOWTO caching data across function calls: temporary tables, cursor?
Previous Message mark 2008-04-01 08:09:23 Re: simple update queries take a long time - postgres 8.3.1