Re: PGSQL, checkpoints, and file system syncs

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

 



> Try setting the vm.dirty_bytes sysctl. Something like 256MB might be a good
> starting point.
> 
> This comes up fairly often, see e.g.:
> http://www.postgresql.org/message-id/flat/27C32FD4-0142-44FE-8488-
> 9F366DC75966@xxxxxxxxxxxxxx
> 
> - Heikki

Thanks, Heikki. That sounds like my problem alright. I will play with these parameters right away, and will report back.

Cheers,
Reza


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance





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

  Powered by Linux