Re: random delays - Mailing list pgsql-general

From Grzegorz Przeździecki
Subject Re: random delays
Date
Msg-id dnfj63$8o0$1@news.hub.org
Whole thread Raw
In response to Re: random delays  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-general
Welcome

Simon Riggs wrote:

>
> Tune your wal settings and bgwriter to improve things, plus upgrade to
> 8.1 which has made leaps forward with this issue.
>

What is best settings for that case?
I have the same on 7.4 but for me it's not critical issue or big problem.
I have database (size 2-3 GB) with image from few kb to 20MB.

> Best Regards, Simon Riggs
>

Best Regards
GP
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

pgsql-general by date:

Previous
From: stig erikson
Date:
Subject: using more then one CPU for queries
Next
From: stig erikson
Date:
Subject: postgresql rpms (8.1.1) for redhat 8.0