Re: First steps with 8.3 and autovacuum launcher
From:
Gregory Stark <stark(at)enterprisedb(dot)com>
To:
"Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc:
"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: First steps with 8.3 and autovacuum launcher
Date:
2007-10-04 15:07:02
Message-ID:
874ph6zzop.fsf@oxford.xeocode.com (view raw or flat )
Thread:
2007-09-18 16:51:04 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-09-19 03:30:05 from Decibel! <decibel(at)decibel(dot)org>
2007-09-19 07:08:58 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-09-19 14:53:29 from Decibel! <decibel(at)decibel(dot)org>
2007-09-22 10:06:57 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-09-22 15:38:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-09-22 16:17:37 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-09-30 18:26:46 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2007-10-01 13:58:44 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-10-01 15:44:02 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2007-10-01 17:15:08 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-10-01 17:35:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-01 17:42:41 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-10-01 19:59:16 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-01 20:26:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-01 20:40:21 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2007-10-01 20:50:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-01 21:33:42 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-01 22:53:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-01 22:56:55 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-01 23:14:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-02 09:23:12 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-01 23:04:39 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2007-10-01 23:28:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-01 23:35:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-01 23:43:45 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-01 23:48:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-02 09:19:54 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-02 14:55:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-02 14:58:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-02 15:17:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-03 14:02:28 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-03 16:42:30 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-03 23:21:09 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-04 09:01:41 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-10-04 12:53:16 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2007-10-04 13:04:06 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-04 15:07:02 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-10-04 15:10:31 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-04 15:45:46 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-10-04 16:55:57 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-04 17:30:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-04 18:33:16 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-04 18:40:46 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-04 19:32:07 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-04 21:33:42 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-05 12:27:54 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-09 20:10:01 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-10 03:52:15 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-10 09:04:34 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-10 09:53:47 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-10 10:17:43 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2007-10-10 10:48:56 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-11 19:59:08 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-11 20:22:46 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 05:24:29 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-10-12 06:17:51 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 06:40:25 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 07:23:57 from Deblauwe Gino <gino(at)useitgroup(dot)com>
2007-10-12 09:08:21 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-12 14:19:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-12 15:02:02 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 15:26:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-12 16:32:47 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 16:42:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-12 17:30:30 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 17:51:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-12 18:16:55 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 09:44:20 from Michael Paesold <mpaesold(at)gmx(dot)at>
2007-10-12 11:00:54 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-12 12:27:31 from Deblauwe Gino <gino(at)useitgroup(dot)com>
2007-10-04 18:42:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-11 13:57:22 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-10-04 14:27:52 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-04 14:43:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-10-04 15:03:00 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-10-01 15:57:03 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
Lists:
pgsql-hackers
"Alvaro Herrera" <alvherre(at)commandprompt(dot)com> writes:
> Hmm, it looks like the race condition Heikki mentioned is the culprit.
> We need a way to stop future analyzes from starting. Back to the
> drawing board ...
A crazy idea I just had -- what if you roll this into the deadlock check? So
after waiting on the lock for 1s it wakes up, finds that the holder it's
waiting on is an autovacuum process and cancels it instead of finding no
deadlock.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
In response to
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2007-10-04 15:10:31Subject : Re: First steps with 8.3 and autovacuum launcherPrevious :From : Simon RiggsDate : 2007-10-04 15:03:00Subject : Re: First steps with 8.3 and autovacuum launcher
