From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | [PATCH] Partial indicies done |
Date: | 2001-07-04 13:38:47 |
Message-ID: | 20010704233847.A8417@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well, there you go. As far as I can tell, with this patch they should work
fine. These are the changes since the last one:
* Fixed the partial index code in all the other index types too.
* Modified the planner to check whether a straight index scan over a partial
index will help.
Actually, I'm not really sure if that second change was necessary. I'll have
to check the formulas, but the partial index will have to be *very*
selective before it comes out ahead of a plain sequential scan.
Now, what it needs is testing but I'm not sure how you test something like
this. And since it shares 90% of the code with the plain index code there's
really very little that can go wrong.
There's one outstanding issue, the "INDEX TUPLES NOT SAME AS HEAP" message.
It's really just a warning but it looks bad. It should be supressed, or even
better, properly checked, but I can't see an easy way to do that since that
function only has the oid.
So, what do I do now? Send it to pgsql-patches?
--
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-index.patch | text/plain | 6.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2001-07-04 13:42:43 | TODO item |
Previous Message | Oliver Vecernik | 2001-07-04 13:38:19 | Re: bit operations |