Skip site navigation (1) Skip section navigation (2)

Re: Patch to add support for partial indices

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch to add support for partial indices
Date: 2001-07-15 04:26:19
Message-ID: 200107150426.f6F4QJO01759@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
I am having trouble applying this patch.  8 of the 9 changes to vacuum.c
failed to apply.

> [Note to list maintainer: I sent this yesterday but it got stuck. I've
> resent it now. If you find it in the queue, you may safely delete it.]
> 
> This patch re-enables support for partial indices. This includes:
> 
> * Updates to documentation
> * Added pg_dump support
> * Corrections to the grammer to accept the CREATE statement
> * Update old broken code each index type
> * Fixes to VACUUM so that it handles indices in general better
> * Updates to the optimiser and cost estimators to handle them
> * Initial steps to removal of EXTEND INDEX statement
> * Patches the regression tests
> 
> Note that Tom Lane has already taken the portion that deals with vacuum as
> part of his new vacuum code.
> 
> As for the extend index statement, it was decided to remove it since it was
> not really flexible enough, so in general you'd be better off just dropping
> the index and recreating it.
> 
> For further discussion, see the pgsql-general list. The patch against
> anonymous CVS as of a day ago or so.
> 
> Many thanks to Tom Lane for tips and pointers during the initial revisions
> of this patch.
> 
> http://svana.org/kleptog/pgsql/partial-indices-7.2.patch
> -- 
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> http://svana.org/kleptog/
> > It would be nice if someone came up with a certification system that
> > actually separated those who can barely regurgitate what they crammed over
> > the last few weeks from those who command secret ninja networking powers.

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

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

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-07-15 04:29:48
Subject: Re: [PATCHES] Re: [PATCH] Cleanup of JDBC character encoding
Previous:From: Bruce MomjianDate: 2001-07-15 04:21:21
Subject: Re: Patch for handling long null terminated strings in JDBC driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group