Re: Contrib reindex script: - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Contrib reindex script:
Date
Msg-id 200206132211.g5DMBYx10018@candle.pha.pa.us
Whole thread Raw
In response to Re: Contrib reindex script:  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Contrib reindex script:  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> Personally I think putting development effort into REINDEX is a waste of
> >> manpower.  Study how to make btree collapse out empty pages, instead.
>
> > Agreed, but what plans do we have to fix it?  I have heard no proposals,
> > and it has been a known problem for years.
>
> Lots of important things have been on the TODO list for years.
> Diverting effort into third-best substitutes isn't going to help get
> them done faster.

Well, not providing tools for people to work around the problem seems
wrong too.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Robert J. Sanford, Jr."
Date:
Subject: Re: read this and puke
Next
From: chris.gamble@CPBINC.com
Date:
Subject: Re: read this and puke