From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Josh Berkus <josh(at)agliodbs(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: We need to log aborted autovacuums
Date:
2011-01-17 01:50:49
Message-ID:
AANLkTi=BQ_u+uMhAeGPgJ1Q-xXpLbgvjaOOv0SOAXStV@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 Sun, Jan 16, 2011 at 8:36 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> I agree with you, but if we want it *this* release, on top of all the
> other features we have queued, then I suggest we compromise. If you hold
> out for more feature, you may get less.
>
> Statement timeout = 2 * (100ms + autovacuum_vacuum_cost_delay) *
> tablesize/(autovacuum_vacuum_cost_limit / vacuum_cost_page_dirty)
I'm inclined to think that would be a very dangerous compromise.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
Next :From: Robert HaasDate: 2011-01-17 01:52:43Subject : Re: psql: Add \dL to show languagesPrevious :From : Robert HaasDate : 2011-01-17 01:49:32Subject : Re: Patch to add a primary key using an existing index
