From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org, Katsuhiko Okano <okano.katsuhiko@oss.ntt.co.jp>
Subject: Re: CSStorm occurred again by postgreSQL8.2
Date: Mon, 7 Aug 2006 16:10:14 -0400
Message-ID: <20060807201014.GB32736@alvh.no-ip.org> (raw)
In-Reply-To: <13175.1154979751@sss.pgh.pa.us>
References: <200607181650.EDC81237.LOBJUTPuIPPBLLV@oss.ntt.co.jp>
<5126.1153241513@sss.pgh.pa.us>
<20060807114525.5266.ITAGAKI.TAKAHIRO@oss.ntt.co.jp>
<19738.1154956177@sss.pgh.pa.us>
<20060807185243.GB26021@alvh.no-ip.org>
<13175.1154979751@sss.pgh.pa.us>
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Tom Lane wrote:
> >> I'm wondering about doing something similar to what
> >> TransactionIdIsInProgress does, ie, make use of the PGPROC lists
> >> of live subtransactions.
>
> > Well, that sounds awfully more expensive than setting
> > local-to-my-database Xmins as well as global (all databases) Xmins :-)
>
> Only when you've got a lot of subtransactions. The point of this
> discussion is to optimize for the few-or-none case. In any case,
> the problem with the local/global bit was that you'd be expending
> foreground-process cycles without any foreground-process return.
> Being able to use a snapshot without consulting pg_subtrans will
> certainly buy back some cycles...
I can buy that. Some idle thoughts:
I was thinking at what time was the most appropiate to insert or remove
an Xid from the cache. We can do without any excl-locking because 1) we
already assume the storing of an Xid to be atomic, and 2) no one can be
interested in querying for an Xid before the originating transaction has
had the chance to write a tuple with that Xid anyway.
OTOH I think we only need to store live Xids and those finished that
wrote a WAL record; we can drop subaborted and subcommitted if they
didn't.
On the third hand, are we going to sh-acquire the ProcArray lock while a
GetSnapshotData copies all subxact Xids of all running transactions?
ProcArrayLock will become more of a contention point than it already is.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@commandprompt.com, tgl@sss.pgh.pa.us, itagaki.takahiro@oss.ntt.co.jp, okano.katsuhiko@oss.ntt.co.jp
Subject: Re: CSStorm occurred again by postgreSQL8.2
In-Reply-To: <20060807201014.GB32736@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox