Re: 8.2 Autovacuum BUG ?

Поиск
Список
Период
Сортировка
От Pavan Teja
Тема Re: 8.2 Autovacuum BUG ?
Дата
Msg-id CACh9nsb8RqkRrtUwfS9CooPAJComUWCJ6A_EeAdVirHKH5JGtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.2 Autovacuum BUG ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: 8.2 Autovacuum BUG ?
Список pgsql-performance
Дерево обсуждения
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.johnston@gmail.com> wrote:
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.

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