On Tue, Jan 23, 2018 at 7:39 AM, Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)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.