From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Peter Much <pmc(at)citylink(dot)dinoex(dot)sub(dot)org> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4801: Performance failure: 600 MB written to each WAL log |
Date: | 2009-05-08 18:15:19 |
Message-ID: | 1241806519.3843.47.camel@ebony.2ndQuadrant |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, 2009-05-08 at 12:26 +0000, Peter Much wrote:
> Server becomes very slow while tremendous amounts of data are written
> to WAL logs - disk activity log shows 600 MB of effective write
> requests before each 16 MB WAL log is archived and recycled.
VACUUM FULL does many things, most of them slowly. It re-writes normal
database blocks setting hint bits, which are not WAL logged. This may
explain the figures you have.
8.2 is also a fairly poor performer with VACUUM and will cause many WAL
unnecessary flushes per WAL file. Not sure why you are using an old
release of PostgreSQL on a new BSD version, but if you upgrade
PostgreSQL and use VACUUM instead you will see improvement.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Much | 2009-05-09 01:29:20 | Re: BUG #4801: Performance failure: 600 MB written to each WAL log |
Previous Message | Tom Lane | 2009-05-08 17:26:47 | Re: Re: 42804: structure of query does not match error where using RETURN QUERY |