Re: Contrib reindex script:

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Neil Conway <nconway@klamath.dyndns.org>, sthomas@townnews.com, pgsql-general@postgresql.org
Date: 2002-06-13T22:11:34Z
Lists: 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