On Tue, Jan 23, 2018 at 7:39 AM, Pavan Teja <pavan.postgresdba@gmail.com> wrote:" checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter".The custom on these lists is to bottom or inline post.This tends to appear when someone decide to write a load script of the form:INSERT INTO tbl (cols) VALUES (...);INSERT INTO tbl (cols) VALUES (...);[repeat many, many, times](note the lack of BEGIN/END, single transaction help mitigate it somewhat)David J.
" checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter".
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных