Re: archive wal's failure and load increase. - Mailing list pgsql-performance

From Tom Lane
Subject Re: archive wal's failure and load increase.
Date
Msg-id 5858.1159478898@sss.pgh.pa.us
Whole thread Raw
In response to archive wal's failure and load increase.  (Cedric Boudin <cedric@dreamgnu.com>)
List pgsql-performance
Cedric Boudin <cedric@dreamgnu.com> writes:
> So the question is: is there a correlation between not getting the wal's
> archived and this "massive" load growth?

Shouldn't be.  Do you want to force the condition again and try to see
*where* the cycles are going?  "High load factor" alone is a singularly
useless report.  Also, how many unarchived WAL files were there?

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Performace Optimization for Dummies
Next
From: Ben
Date:
Subject: any hope for my big query?