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) wi
Simon Riggs <[EMAIL PROTECTED]> writes:
> You'll find response times spike somewhat during Checkpoints. We've been
> working to reduce this effect for some time and there is still more work
> to be done.
>
> Tune your wal settings and bgwriter to improve things, plus upgrade to
> 8.1 which has m
On Fri, 2005-12-09 at 14:29 +0100, Baldur Norddahl wrote:
> I noticed that sometimes we seem to have a problem with simple queries
> that take a long time to execute. For example "select * from config
> where key='abc'" which normally only takes a few milliseconds, but in
> some rare cases sudd
On Fri, Dec 09, 2005 at 02:29:02PM +0100, Baldur Norddahl wrote:
> I noticed that sometimes we seem to have a problem with simple queries
> that take a long time to execute. For example "select * from config
> where key='abc'" which normally only takes a few milliseconds, but in
> some rare case
