Re: Patch to add support for partial indices - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Patch to add support for partial indices
Date
Msg-id 200107161437.f6GEbxp06154@candle.pha.pa.us
Whole thread Raw
In response to Patch to add support for partial indices  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-patches
Patch applied by Tom.

> [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@svana.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@postgresql.org

--
  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-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch to add support for partial indices
Next
From: Bruce Momjian
Date:
Subject: Re: Clear out the reminants of EXTEND INDEX