Re: autovacuum locks

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <gryzman(at)gmail(dot)com>,<robertmhaas(at)gmail(dot)com>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <alvherre(at)commandprompt(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autovacuum locks
Date: 2012-03-05 14:34:37
Message-ID: 4F547A9D0200002500045F19@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregg Jaskiewicz wrote:

> Also, on the subject of prepared transactions (2PC), the "select *
> from pg_prepared_xacts ;" query simply does not reveal anything,
> despite the fact that I know that there should be at least two of
> those open.
> Unless it only list saved transactions, not a transaction in the
> middle of operation.

Transactions only appear there between the PREPARE statement and the
COMMIT. Hopefully that is a small window of time for each
transaction.

-Kevin

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-03-05 15:03:18 Checksums, state of play
Previous Message Alexander Korotkov 2012-03-05 14:02:24 Re: Collect frequency statistics for arrays