Patch to add support for partial indices

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: Patch to add support for partial indices
Date: 2001-07-12 23:28:44
Message-ID: 20010713092844.A8531@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

[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 Content-Type Size
partial-indices-7.2.patch text/plain 30.8 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-07-13 00:56:55 Re: Patch to add support for partial indices
Previous Message Barry Lind 2001-07-12 21:16:41 Patch for handling long null terminated strings in JDBC driver