From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Davis <pgsql(at)j-davis(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: New VACUUM FULL
Date:
2009-12-28 16:35:24
Message-ID:
603c8f070912280835qa4e2733m9fc18f906665ec2f@mail.gmail.com (view raw or flat )
Thread:
2009-10-23 03:08:06 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-10-23 06:55:17 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-10-26 02:54:17 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-10-27 04:55:02 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-11-12 09:51:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-11-12 13:13:56 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-12 13:17:58 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-12 13:22:04 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-13 01:47:15 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-11-14 21:41:00 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-14 22:12:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-14 23:26:17 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-16 04:37:33 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-11-16 05:59:27 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-16 21:33:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-27 23:12:16 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-30 05:38:59 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-11-30 20:10:43 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-30 21:22:25 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-12-01 09:43:30 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-12-04 09:20:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-04 17:56:52 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-12-04 18:36:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-04 23:07:18 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-12-05 00:49:05 from Michael Glaesemann <grzm(at)seespotcode(dot)net>
2009-12-05 18:56:03 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-12-07 05:31:31 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-07 06:26:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-07 07:55:26 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-15 09:05:26 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-15 13:50:13 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-16 00:11:15 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-15 17:44:22 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-12-21 10:54:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-21 12:56:41 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-12-21 13:48:05 from Greg Stark <gsstark(at)mit(dot)edu>
2009-12-22 09:11:41 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-22 09:37:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-22 10:10:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-22 10:45:55 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2009-12-22 12:29:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-12-28 16:35:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-04 02:50:56 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-01-04 08:04:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-04 15:31:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-04 16:57:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-04 20:03:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-04 20:05:48 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-04 20:51:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-04 21:41:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-05 00:19:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-05 00:29:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-05 01:35:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-05 01:53:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-05 19:01:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-06 05:41:59 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-01-06 09:11:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-06 09:59:42 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-01-30 14:05:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-30 14:38:31 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-11-15 00:07:56 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-15 00:25:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-15 01:26:38 from Jeff Davis <pgsql(at)j-davis(dot)com>
2009-11-16 09:29:42 from Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Lists:
pgsql-hackers
On Tue, Dec 22, 2009 at 7:29 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Tue, 2009-12-22 at 19:45 +0900, Takahiro Itagaki wrote:
>
>> I used "VACUUM FULL" because we were discussing to drop VFI completely,
>> but I won't replace the behavior if hot-standby can support VFI.
>
> HS can't support VFI now, by definition. We agreed to spend the time
> getting rid of VFI, which working on this with you is part of.
>
> If we can just skip the index rebuild, I think that's all the additional
> code changes we need. I'll improve the docs as I review-to-commit.
So, what is the roadmap for getting this done? It seems like to get
rid of VFI completely, we would need to implement something like what
Tom described here:
http://archives.postgresql.org/pgsql-hackers/2009-09/msg00249.php
I'm not sure whether the current patch is a good intermediate step
towards that ultimate goal, or whether events have overtaken it.
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Peter EisentrautDate: 2009-12-28 16:50:02Subject : psql 8.4 \c repeats version bannerPrevious :From : Bruce MomjianDate : 2009-12-28 16:31:13Subject : Re: Removing pg_migrator limitations
