Re: Prepared transactions vs novice DBAs, again

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Prepared transactions vs novice DBAs, again
Date: 2009-05-05 15:45:17
Message-ID: EE6189DDFF6C4E9BE9C6F898@teje
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Dienstag, Mai 05, 2009 15:29:15 +0000 Greg Sabino Mullane
<greg(at)turnstep(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-05-05 15:50:22 Serializable Isolation without blocking
Previous Message Tom Lane 2009-05-05 15:40:10 Re: Prepared transactions vs novice DBAs, again