On Tue, Jul 13, 2010 at 9:10 PM, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote: >> And tomorrow I will see how my nightly backup runs with this setting. > > It sounds like it's time for a post to the Linux Kernel Mailing List, > and/or a Launchpad bug against the Ubuntu kernel. > > Make sure to have your asbestos undewear on if posting to LKML ;-) Note that I am testing a new 48 core machine with gobs of ram under ubuntu 10.04, so I'll do some testing to see if I get the same kind of issue, especially once I subscribe one of these machines to the slony farm and get some action going on it to fill its buffers. Note that the page posted earlier that described zone_reclaim_mode said that when the memory is mostly used for file caching it's a good idea to set it to 0. Even though they said that they were talking about file servers, I'd assume that applies to pgsql as well, since it's normal to use most of the extra memory as file system cache. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
