Re: (Relatively) Oversized Checkpoint

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: (Relatively) Oversized Checkpoint
Дата
Msg-id CADp-Sm67upU8aiHSbx=L08EhMTGLkJwfiwn42Bt38WVojoB8cA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: (Relatively) Oversized Checkpoint  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
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).



Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Sameer Kumar
Дата:
Сообщение: Re: HOT standby with ONLY WAL shipping?
Следующее
От: Khangelani Gama
Дата:
Сообщение: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column