From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Greg Smith <greg(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: We need to log aborted autovacuums
Date:
2011-01-15 19:29:54
Message-ID:
AANLkTi=t_ay3Rq3LQW=N8VH9Tuj_npSufe88zLLChaaY@mail.gmail.com (view raw or flat )
Thread:
2010-11-17 21:46:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-11-17 21:55:40 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-11-17 22:50:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-17 23:31:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-11-17 23:35:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-17 23:49:24 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2010-11-17 23:52:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-05 06:55:02 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-05 12:29:39 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-01-05 19:27:10 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-05 22:56:51 from Robert Treat <rob(at)xzilla(dot)net>
2011-01-05 23:06:11 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-07 04:11:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-07 04:33:23 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-07 19:00:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-08 01:15:12 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-08 06:05:20 from David Fetter <david(at)fetter(dot)org>
2011-01-08 12:17:51 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-15 09:47:56 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-15 16:14:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-15 19:29:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-16 16:23:16 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 16:47:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 17:18:22 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-16 18:08:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 18:08:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 18:20:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 19:19:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-16 20:50:08 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-17 01:36:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-17 01:50:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-17 19:46:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-17 20:24:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-17 21:08:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-31 02:37:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-31 03:03:19 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-31 03:26:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 03:49:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 12:08:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 17:54:28 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-05 18:40:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 20:20:57 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-05 20:25:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 20:34:15 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-08 03:05:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 01:26:09 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-18 02:12:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 03:04:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 06:41:29 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-16 18:22:38 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 18:26:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
On Sat, Jan 15, 2011 at 11:14 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Greg Smith <greg(at)2ndquadrant(dot)com> writes:
>> Does try_relation_open need to have a lock acquisition timeout when AV
>> is calling it?
>
> Hmm. I think when looking at the AV code, I've always subconsciously
> assumed that try_relation_open would fail immediately if it couldn't get
> the lock. That certainly seems like it would be a more appropriate way
> to behave than delaying indefinitely.
I'm confused how that's not happening already. What does "try" mean, otherwise?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2011-01-15 19:31:21Subject : Re: ALTER TYPE 0: Introduction; test casesPrevious :From : Robert HaasDate : 2011-01-15 19:27:21Subject : Re: LOCK for non-tables
