[PATCH] Partial indices almost there - Mailing list pgsql-general

From Martijn van Oosterhout
Subject [PATCH] Partial indices almost there
Date
Msg-id 20010711153419.A2082@svana.org
Whole thread Raw
List pgsql-general
Well, I've done the patch against the latest CVS this time, making it easier
to merge in later.

Major features:
* You can create partial indices
* You can pg_dump them
* They have documentation
* The database will use them
* Disables EXTEND INDEX pending complete removal

Remaining issue:
* Vacuum destroys your index's partialness

I'm going to work on that tonight, I'll see how far I get.

You'll need to do an initdb after this (I think) because it adds a new
internal function. I used OID 1716, I hope nobody is using that one right
now.

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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: View prevents index
Next
From: "Joe Conway"
Date:
Subject: Re: [PATCH] Partial indices almost there