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

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 00:00:33
Message-ID: 20010712100033.A5399@svana.org (view raw or flat)
Thread:
Lists: pgsql-patches
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.

pgsql-patches by date

Next:From: markMLl.pgsql-generalDate: 2001-07-12 08:02:03
Subject: Re: 2 gig file size limit
Previous:From: Bruce MomjianDate: 2001-07-11 22:19:31
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword

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