| 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
| 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 |