From:
Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To:
Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc:
"Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>,Andrew Dunstan <andrew(at)dunslane(dot)net>, swm(at)linuxworld(dot)com(dot)au,postgres(at)cybertec(dot)at, alvherre(at)surnet(dot)cl, pgman(at)candle(dot)pha(dot)pa(dot)us,pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Autovacuum in the backend
Date:
2005-06-16 14:13:49
Message-ID:
42B1891D.1020609@pse-consulting.de (view raw or flat )
Thread:
2005-06-06 15:16:22 from Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
2005-06-07 00:33:26 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-07 11:16:19 from Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
2005-06-07 15:16:06 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-07 15:35:31 from Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
2005-06-07 16:00:54 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-07 16:04:28 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-07 16:42:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-10 03:51:55 from "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
2005-06-10 14:12:28 from Shelby Cain <alyandon(at)yahoo(dot)com>
2005-06-11 01:23:06 from "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
2005-06-11 12:44:32 from Hugo <htakada(at)gmail(dot)com>
2005-06-15 09:43:58 from Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>
2005-06-11 16:54:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-15 01:23:51 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-15 03:00:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-15 03:26:51 from "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
2005-06-15 03:23:20 from "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
2005-06-15 05:26:56 from Neil Conway <neilc(at)samurai(dot)com>
2005-06-15 05:41:52 from "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
2005-06-15 08:56:09 from Hannu Krosing <hannu(at)skype(dot)net>
2005-06-15 12:49:22 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-15 19:45:00 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-15 09:04:46 from "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
2005-06-15 14:04:22 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-15 19:48:24 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 01:07:31 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-16 01:45:08 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 02:54:58 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 03:45:04 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2005-06-16 03:57:45 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2005-06-16 04:07:30 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 04:14:10 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-16 14:05:01 from Steve Atkins <steve(at)blighty(dot)com>
2005-06-17 07:00:59 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2005-06-17 11:58:53 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 04:44:20 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 05:14:17 from Rod Taylor <pg(at)rbt(dot)ca>
2005-06-17 07:03:26 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2005-06-17 07:16:16 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2005-06-17 08:56:17 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2005-06-17 12:11:50 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-17 12:04:35 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-17 14:35:48 from Rod Taylor <pg(at)rbt(dot)ca>
2005-06-17 16:18:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 03:56:41 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-16 04:46:11 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 06:20:34 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-16 09:06:42 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2005-06-16 09:34:05 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-16 09:59:49 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2005-06-16 10:55:40 from "Andrew Dunstan" <andrew(at)dunslane(dot)net>
2005-06-16 13:47:24 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 14:13:49 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-06-16 14:04:00 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 13:06:55 from Christopher Browne <cbbrowne(at)acm(dot)org>
2005-06-17 16:21:44 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-18 00:04:36 from "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
2005-06-16 14:01:53 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-17 09:05:01 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2005-06-17 09:18:30 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-16 15:11:20 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 15:29:47 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2005-06-16 22:22:16 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-17 04:55:34 from "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
2005-06-16 03:45:45 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 04:08:20 from Neil Conway <neilc(at)samurai(dot)com>
2005-06-16 04:52:23 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-17 02:15:37 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-17 09:01:15 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2005-06-17 09:16:14 from Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
2005-06-21 20:06:52 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-15 14:05:51 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-15 14:10:40 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-15 17:01:31 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-15 19:55:55 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 01:26:58 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-16 01:50:05 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 03:42:17 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 03:55:47 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 04:04:33 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 04:09:47 from Neil Conway <neilc(at)samurai(dot)com>
2005-06-16 04:27:43 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 04:56:36 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 04:58:01 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 05:32:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 15:08:33 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-16 15:42:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 16:54:39 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 17:12:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 17:41:38 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-16 18:42:13 from Hannu Krosing <hannu(at)skype(dot)net>
2005-06-17 02:12:06 from "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
2005-06-17 08:26:46 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-06-17 09:08:07 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2005-06-17 12:21:23 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-17 13:54:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 16:13:54 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 16:24:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2005-06-16 16:29:43 from Douglas McNaught <doug(at)mcnaught(dot)org>
2005-06-17 01:04:33 from Tim Allen <tim(at)proximity(dot)com(dot)au>
2005-06-15 08:50:42 from Hannu Krosing <hannu(at)skype(dot)net>
2005-06-15 20:02:34 from "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
2005-06-15 20:21:30 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-general pgsql-hackers
Matthew T. O'Connor wrote:
>
> Right, I think if VACUUM is improved than the semantics of AV in the
> backend might change, but I think there will always be a need for some
> maintenance, and a daemon that monitors the maintenance needs of your
> database and fires off appropriate maintenance commands for you is
> good. No it doesn't solve all problems, but I think it solves a lot of
> problems for a lot of people. Besides VACUUM isn't the only the AV
> does, it also does ANALYZE to keep your stats up-to-date and it watches
> for XID wraparound. It could also look for REINDEX opportunities and
> who knows what else in the future.
Dave,
i wonder if we should aim to have pgAgent in the backend which was one
of the reasons why I considered to have it converted from C++ to pure C.
There are many regular maintenance issues that AV can cover, some more
it could cover and many more we can't even think of right now. Having an
sql executing agent freely at hand (consistent on _every_ platform,
without cron/anacron/at/younameit dependencies) should be helpful for that.
Regards,
Andreas
In response to
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2005-06-16 14:27:27Subject : Re: Escape handling in stringsPrevious :From : Steve AtkinsDate : 2005-06-16 14:05:01Subject : Re: Autovacuum in the backend
pgsql-general by date
Next :From: Tom LaneDate: 2005-06-16 14:26:20Subject : Re: DATATYPE for HEX Previous :From : Steve AtkinsDate : 2005-06-16 14:05:01Subject : Re: Autovacuum in the backend
