Postgres Pro
Downloads
Home   >   mailing lists

Re: (Relatively) Oversized Checkpoint - Mailing list pgsql-general

From Sameer Kumar
Subject Re: (Relatively) Oversized Checkpoint
Date
Msg-id CADp-Sm67upU8aiHSbx=L08EhMTGLkJwfiwn42Bt38WVojoB8cA@mail.gmail.com
Whole thread Raw
In response to Re: (Relatively) Oversized Checkpoint  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
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

icons

 

Email patch

 

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).



Attachment

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: HOT standby with ONLY WAL shipping?
Next
From: Khangelani Gama
Date:
Subject: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column