From:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>,"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Thoughts on maintaining 7.3
Date:
2003-10-04 03:42:00
Message-ID:
200310040342.h943g0s02139@candle.pha.pa.us (view raw or flat )
Thread:
2003-09-30 16:37:26 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 12:36:43 from "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
2003-10-01 13:14:07 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2003-10-01 13:41:18 from "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
2003-10-01 15:50:14 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2003-10-01 17:58:51 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 18:55:51 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2003-10-01 14:49:22 from Neil Conway <neilc(at)samurai(dot)com>
2003-10-01 15:40:23 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2003-10-01 15:48:56 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 16:39:54 from Neil Conway <neilc(at)samurai(dot)com>
2003-10-05 13:41:03 from Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
2003-10-01 17:48:44 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 14:44:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-01 13:19:51 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
2003-10-01 17:47:57 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 19:11:02 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
2003-10-01 19:31:54 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 19:49:55 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2003-10-01 20:02:47 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 23:11:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-02 17:47:06 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-02 19:15:33 from Bruno Wolff III <bruno(at)wolff(dot)to>
2003-10-03 15:17:15 from Andrew Sullivan <andrew(at)libertyrms(dot)info>
2003-10-03 16:17:16 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-03 16:39:55 from Doug McNaught <doug(at)mcnaught(dot)org>
2003-10-03 16:47:58 from "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
2003-10-07 12:03:10 from Andrew Sullivan <andrew(at)libertyrms(dot)info>
2003-10-07 15:34:24 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-07 15:52:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2003-10-07 15:58:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-07 17:59:12 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-07 18:21:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-07 18:01:42 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-08 01:28:40 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2003-10-03 21:41:45 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-03 22:28:07 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-03 22:20:55 from "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
2003-10-01 19:35:15 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-10-01 23:09:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-02 12:28:08 from Rod Taylor <rbt(at)rbt(dot)ca>
2003-10-03 21:37:52 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-04 03:36:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-04 03:42:00 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-04 15:41:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-05 03:13:34 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-10-05 03:53:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-05 20:31:33 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-10-05 21:41:59 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-09 19:36:12 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-05 03:17:09 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-05 03:26:56 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-10-05 03:57:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-05 04:40:37 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-05 06:11:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-05 14:28:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-09 19:30:18 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-09 19:34:27 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-10-01 22:11:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-01 22:23:16 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 22:35:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-10-01 15:40:57 from Andrew Sullivan <andrew(at)libertyrms(dot)info>
2003-10-01 15:49:51 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2003-10-01 16:30:31 from Andrew Sullivan <andrew(at)libertyrms(dot)info>
Lists:
pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Though the new code will put empty index pages into the free-space map,
> > will it also shrink the index file to remove those pages?
>
> If there are free pages at the end, yes --- but it won't move pages
> around. This is about the same story as for plain VACUUM ...
I know indexes behave the same as heap for vacuum. My point was that
the vacuum full case is different. Vacuum full moves heap tuples from
the end to fill slots and then frees the pages at the end via
truncation. (100% compaction, guaranteed.) We can't move index tuples
around like that, of course, so that leaves us with partially filled
pages.
Do we move empty index pages to the end before truncation during vacuum
full?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2003-10-04 03:55:42Subject : Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ... Previous :From : Tom LaneDate : 2003-10-04 03:36:57Subject : Re: Thoughts on maintaining 7.3
