From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Davis <pgsql(at)j-davis(dot)com>, jd(at)commandprompt(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Prepared transactions vs novice DBAs, again
Date:
2009-04-22 21:15:11
Message-ID:
603c8f070904221415p58f01ec8t45d7d34f934941bf@mail.gmail.com (view raw or flat )
Thread:
2009-04-22 17:48:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 17:53:11 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-04-22 18:55:27 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-04-22 18:00:01 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2009-04-22 18:22:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-22 18:30:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 18:40:56 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-22 18:48:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 19:49:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 19:53:15 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2009-04-22 20:26:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-23 14:36:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-04-28 18:36:07 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2009-04-22 18:37:16 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-04-22 18:27:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 18:43:07 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-04-22 18:53:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 18:58:53 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-22 19:03:15 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-04-22 19:08:50 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-22 21:15:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-04-22 21:44:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-23 00:49:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-04-23 00:58:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-23 01:21:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-04-23 02:14:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-04-23 03:04:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 18:28:45 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2009-05-05 15:29:15 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2009-05-05 15:40:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-05 15:45:17 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-05-05 15:56:18 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Lists:
pgsql-hackers
On Wed, Apr 22, 2009 at 2:58 PM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> Tom Lane wrote:
>>
>> Does a prepared xact still block vacuum cleanup in HEAD, or has that
>> been fixed since 8.2?
>
> It still does. A prepared xact is just like a idle-in-transaction backend as
> far as vacuum is concerned.
Is that really necessary? It's true that you can't vacuum away any
rows whose xmin is that of the prepared xact, but it seems like you
wouldn't need to keep rows just because they were *visible* to the
prepared xact. Once prepared, it's no longer capable of reading them.
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Hiroshi InoueDate: 2009-04-22 21:35:28Subject : Re: trouble with to_char('L')Previous :From : Tom LaneDate : 2009-04-22 20:26:49Subject : Re: Prepared transactions vs novice DBAs, again
