From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | reference regarding write load during different stages of checkpoint |
Date: | 2018-09-26 20:05:00 |
Message-ID: | 20180926200500.GA493@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I'm hoping to find a document I once read about the write load.
As best I can recall, it looked something like this:
. at beginning of (spread) checkpoint, larger than average write load to
pg_wal/, due to full_page_writes;
. during most of checkpoint, decreasing WAL due to FPW,
. towards end of checkpoint, increased writes to table data base/, due to
fsync();
. assuming the next checkpoint doesn't start immediately, quiescent period, due
to clean OS buffers;
This isn't very important, but I hadn't seen that described before, and
I think there was more detail than I can remember.
I've been hoping for awhile to run across it and not able to find it. It
probably dates back to 8.3/9.0 days and maybe disappeared.
Does anyone know what I'm talking about or where I can find it?
Thanks,
Justin
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2018-09-27 09:25:58 | Re: Why could different data in a table be processed with different performance? |
Previous Message | Vladimir Ryabtsev | 2018-09-26 17:15:15 | Re: Why could different data in a table be processed with different performance? |