Re: Segment best size

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

 






On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza <rodrigombufrj@xxxxxxxxx> wrote:


I was receiving warning messages of pgstat timeout.
I started looking for the solution for this problem and this doubt came out.
But it doesn't seem to be the problem.

Usually that just means that you are dirtying pages faster than your hard drives can write them out, leading to IO contention.  Sometimes you can do something about this by changing the work-load to dirty pages in more compact regions, or by changing the configuration.  Often the only effective thing you can do is buy more hard-drives.

Cheers,

Jeff


Would it help if I changed the checkpoint_completion_target to something close to 0.7 (mine is the default 0.5) or raise the checkpoint_segments (it is 32 now)?

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

  Powered by Linux