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
> Since you have a very big toast table, given you are using spinning
disks, I think that increasing the block size will bring benefits.
But will it worsen caching? I will have lesser slots in cache. Also will it
affect required storage space?
>> consecutive runs with SAME parameters do NOT hit th
