Search Postgresql Archives

Re: PostgreSQL 10.12. background writer not cleaning buffers, small working set, big shared_buffers

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

 



Any ideas on this guys?

Thank you. 

On Fri, Aug 14, 2020 at 1:39 AM Rene Romero Benavides <rene.romero.b@xxxxxxxxx> wrote:
Hello Postgres community.
In a few words I'm figuring out this stats from the background writer where you can see buffers_clean is 0 and buffers_backend = 44849371, I would like it to be the other way around, that's more efficient, right?

-[ RECORD 1 ]---------+------------------------------
checkpoints_timed     | 97504
checkpoints_req       | 4
checkpoint_write_time | 21171407908
checkpoint_sync_time  | 684641
buffers_checkpoint    | 273934008
buffers_clean         | 0
maxwritten_clean      | 0
buffers_backend       | 44849371
buffers_backend_fsync | 0
buffers_alloc         | 44744713
stats_reset           | 2019-09-10 08:42:34.490899-07

Using default settings 
postgres=# select name,setting,unit from pg_settings where name like '%bgwriter%'
;
          name           | setting | unit
-------------------------+---------+------
 bgwriter_delay          | 200     | ms
 bgwriter_flush_after    | 64      | 8kB
 bgwriter_lru_maxpages   | 100     |
 bgwriter_lru_multiplier | 2       | 

shared_buffers = '6GB'
and the VM has a RAM of 24GB 

The working set is about 160MB, I know, shared buffers are oversized for this DB, and I know that the bgwriter is supposed to do work when the working set doesn't fit into shared_buffers, but backends cleaning their buffers produces undesirable sync waits, right ?
Any advice ?

Thank you.


--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison




--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux