Hi David, If it's yes what needs to be done in order to stabilize this issue??
Thanks in advance. Regards, Pavan On Jan 23, 2018 8:15 PM, "David G. Johnston" <david.g.johns...@gmail.com> wrote: > On Tue, Jan 23, 2018 at 7:39 AM, Pavan Teja <pavan.postgres...@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. > >
