9.6 write time

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: 9.6 write time
Date: 2021-12-28 16:52:25
Message-ID: CADX_1ab-t3Lderkh_bB4_F60RVgN9UkR1UvYKSmE8WEdEAbDwQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I am looking at a postgres 9.6 on rh7
I see that checkpoint_write_time is huge which looks quite strange as the
average amount of data written is not that big.
For example in 5:30 hours today, data from pg_stat_bgwriter view, comparing
values at 11AM and 4h30PM :
checkpoint_write_time 6986324
buffers_checkpoint 182447

so, to my understanding, it takes almost 2 hours to write 1.6 GB of data.

Can someone either correct my understanding, or shed some light on what can
cause this ??

thanks,

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2021-12-28 17:46:44 Re: 9.6 write time
Previous Message Laurenz Albe 2021-12-23 10:04:09 Re: WAL files keep piling up