Re: Prepared transactions vs novice DBAs, again - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Prepared transactions vs novice DBAs, again
Date
Msg-id EE6189DDFF6C4E9BE9C6F898@teje
Whole thread Raw
In response to Re: Prepared transactions vs novice DBAs, again  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Prepared transactions vs novice DBAs, again  ("Greg Sabino Mullane" <greg@turnstep.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Prepared transactions vs novice DBAs, again
Next
From: "Kevin Grittner"
Date:
Subject: Serializable Isolation without blocking