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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-patches by date

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