Very long COMMIT times?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Very long COMMIT times?
Дата
Msg-id 9sphq7$k0h$1@news.tht.net
обсуждение исходный текст
Список pgsql-admin
We've been adjusting the WAL log file count on our database.  The only
effects we've seen so far in increasing the count from 8 (default) to 32
(current) are:

1) No more WAL messages in the log 8-/

and 2) very long COMMIT times for some long transactions: I'm talking
about upwards of 10-20 MINUTES to commit after doing hundreds of inserts,
updates and deletes in one transaction.  The table involved has some 20K
rows, and is read and updated a few rows at a time by many processes, but
only one (the one doing large numbers of rows) has the lengthy COMMIT
times.

Did this come about because of the increase in WAL count?

--
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com

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

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: [Solution] PG 7.1.3 & MacOS X (10.1)
Следующее
От: "Jeff Boes"
Дата:
Сообщение: Re: Very long COMMIT times?