Home > mailing lists

Re: 8.2 Autovacuum BUG ? - Mailing list pgsql-performance

From	David G. Johnston
Subject	Re: 8.2 Autovacuum BUG ?
Date	January 23, 2018 20:45:14
Msg-id	CAKFQuwaPT1VuD1UyyHAOhk=nWj2mHUmHgz2XZtXKfwcVpXqGvQ@mail.gmail.com Whole thread Raw
In response to	Re: 8.2 Autovacuum BUG ? (Pavan Teja <pavan.postgresdba@gmail.com>)
Responses	Re: 8.2 Autovacuum BUG ?
List	pgsql-performance

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 (...);

[repeat many, many, times]

(note the lack of BEGIN/END, single transaction help mitigate it somewhat)

David J.

From: Pavan Teja
Date: 23 January 2018, 20:39:27
Subject: Re: 8.2 Autovacuum BUG ?

From: Andreas Kretschmer
Date: 23 January 2018, 20:57:40
Subject: Re: 8.2 Autovacuum BUG ?