Re: (Relatively) Oversized Checkpoint
As pointed out you may want to look at some of your kernel parameters which control the writeback (from cache) to disk.
Additionally you may want to take a look bg write parameters. Specially bgwriter delay. I guess tuning that should help as well.
It might be useful if you can share your parameter file here.
Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
В списке pgsql-general по дате отправления: