Re: Fwd: wal_sync_methods for AIX

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 19 Feb 2008, JP Fletcher wrote:

Shared buffers are set to 50000, bgwriter settings are as follows:

bgwriter_delay = 50 # 10-10000 milliseconds between rounds
bgwriter_lru_percent = 20.0             # 0-100% of LRU buffers scanned/round
bgwriter_lru_maxpages = 300             # 0-1000 buffers max written/round
bgwriter_all_percent = 5                # 0-100% of all buffers scanned/round
bgwriter_all_maxpages = 600             # 0-1000 buffers max written/round

Not that it impacts what you're asking about, but that's probably an excessive setting for bgwriter_lru_percent. With the reduced delay and scanning that much, you're burning a lot of CPU time doing that for little benefit.

--
* Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux