Re: Question about buffers_alloc in pg_stat_bgwriter view for monitoring

2018-03-30 Thread Achilleas Mantzios
On 29/03/2018 20:24, Alvar Freude wrote: Hi, Am 29.03.2018 um 10:30 schrieb Gunnar Nick Bluth : Thus, buffer_alloc is the global count of buffers allocated in the cluster. That it appears in the bgwriter statistics is more or less coincidental. But it seems not to be the total shared_buffers

Re: Question about buffers_alloc in pg_stat_bgwriter view for monitoring

2018-03-29 Thread Alvar Freude
Hi, > Am 29.03.2018 um 10:30 schrieb Gunnar Nick Bluth : > > Thus, buffer_alloc is the global count of buffers allocated in the > cluster. That it appears in the bgwriter statistics is more or less > coincidental. But it seems not to be the total shared_buffers used, but the total number of all

Re: Question about buffers_alloc in pg_stat_bgwriter view for monitoring

2018-03-29 Thread Alvar C.H. Freude
Hi, > Am 29.03.2018 um 10:30 schrieb Gunnar Nick Bluth : > > Thus, buffer_alloc is the global count of buffers allocated in the > cluster. That it appears in the bgwriter statistics is more or less > coincidental. So it is the number of shared_buffers used? This isn’t possible: postgres=# SELE

Re: Question about buffers_alloc in pg_stat_bgwriter view for monitoring

2018-03-29 Thread Gunnar "Nick" Bluth
Am 28.03.2018 um 23:38 schrieb Alvar Freude: > Hi all, > > Can someone tell me, what the value of buffers_alloc in the pg_stat_bgwriter > view > (https://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-BGWRITER-VIEW) > is exactly? Is this the amount of shared buffers used b