On Fri, 2008-05-02 at 12:28 -0400, Greg Smith wrote: > As PostgreSQL makes its way into higher throughput environments, it > wouldn't surprise me to discover more of these situations where switching > WAL segments every 16MB turns into a bottleneck.
We already hit that issue and fixed it early in the 8.3 cycle. It was more of a problem than the checkpoint issue because it caused hard lock-outs while the file switches occurred. It didn't show up unless you looked at the very detailed transaction result data because on fast systems we are file switching every few seconds. Not seen any gains from varying the WAL file size since then... -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches
