| From: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
|---|---|
| To: | mark <markkicks(at)gmail(dot)com> |
| Cc: | Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: simple update queries take a long time - postgres 8.3.1 |
| Date: | 2008-04-02 07:47:14 |
| Message-ID: | 47F33A02.4010709@batory.org.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2008-04-02 09:30, mark wrote:
> Based on what Tomasz suggested a day ago, I had changed settings to
> checkpoint_segments = 16
> checkpoint_timeout = 20min
> checkpoint_completion_target = 0.8
> but i still do get statements that take over 2 or 3 seconds to execute
> sometimes... should I increase checkpoint_segments to 30 now?
Go for it. Even 64 (I like round numbers) would not be too much. This
would make 1GB of data in WALs.
> Should I change checkpoint_timeout & checkpoint_completion_target too??
I'd recommend not. Too much and your recovery time would be in hours.
And too big checkpoint_completion_target could make your original
problem even worse.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2008-04-02 08:11:52 | Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor? |
| Previous Message | A. Kretschmer | 2008-04-02 07:41:14 | Re: Is there an md5sum for tables? |