From: | "Pavan Deolasee" <pavan(dot)deolasee(at)enterprisedb(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: CIC and deadlocks |
Date: | 2007-04-09 13:52:52 |
Message-ID: | 461A4534.70601@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> writes:
>
> Good point. I'm envisioning a procarray.c function along the
> lines of
> bool TransactionHasSnapshot(xid)
> which returns true if the xid is currently listed in PGPROC
> and has a nonzero xmin. CIC's cleanup wait loop would check
> this and ignore the xid if it returns false. Your point means
> that this function would have to take exclusive not shared lock
> while scanning the procarray, which is kind of annoying, but
> it seems not fatal since CIC isn't done all that frequently.
>
Tom,
If you haven't finished this yet, would you like me to work
on this ? If I do it, I would mostly follow the path you
suggested above, unless I run into something else.
Thanks,
Pavan
--
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Shaunak Godbole | 2007-04-09 14:02:10 | Query |
Previous Message | Alvaro Herrera | 2007-04-09 13:40:00 | Re: autovacuum multiworkers, patch 5 |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-04-09 14:14:41 | Re: [HACKERS] Arrays of Complex Types |
Previous Message | Alvaro Herrera | 2007-04-09 13:40:00 | Re: autovacuum multiworkers, patch 5 |