: bg_writer overloaded ?

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

 



Hello Everyone,

I could see the following in the production server (result of the "top" M command) -

 PID    USER     PR  NI  VIRT    RES   SHR   S  %CPU   %MEM       TIME+     COMMAND
25265 postgres  15   0  3329m   2.5g   1.9g   S     0.0          4.0      542:47.83   postgres: writer process

The "writer process" refers to bg_writer ? and we have shared_buffers set to 1920 MB (around 1.9 GB).

In an other similar situation, we have "postgres writer process" using up 7 - 8 GB memory constantly. 

pg_tune is suggesting to increase the shared_buffers to 8 GB.

If the shared_buffer is not enough, Postgres uses OS cache ?

We have a 64 GB RAM.

We have decided the following -

1. We have 20 databases running in one cluster and all are more or less highly active databases.
2. We will be splitting across the databases across multiple clusters to have multiple writer processes working across databases.

Please help us if you have any other solutions around this.

Thanks
VB


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

  Powered by Linux