[PATCH] Partial indices almost there

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: [PATCH] Partial indices almost there
Date: 2001-07-11 05:34:19
Message-ID: 20010711153419.A2082@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2001-07-11 05:58:41 Re: [PATCH] Partial indices almost there
Previous Message Tom Lane 2001-07-11 05:10:04 Re: View prevents index