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.
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 |