Re: Prepared transactions vs novice DBAs, again

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: Prepared transactions vs novice DBAs, again
Дата
Msg-id EE6189DDFF6C4E9BE9C6F898@teje
обсуждение исходный текст
Ответ на Re: Prepared transactions vs novice DBAs, again  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Prepared transactions vs novice DBAs, again  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-hackers
--On Dienstag, Mai 05, 2009 15:29:15 +0000 Greg Sabino Mullane 
<greg@turnstep.com> wrote:

> It simply checks the age of entries in pg_prepared_xacts and gives
> a warning if the number is at or over the given threshhold (defaults
> to 1 second). I'm still a heavy +1 on making the default Postgres
> configuration value 0, but hopefully this will help.

1 seconds seems a very low default for me. I can imagine that most 
distributed transactions are taking longer than this to complete.

--  Thanks
                   Bernd


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Prepared transactions vs novice DBAs, again
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Serializable Isolation without blocking