> Right. As I remember, your solution does basically the same
> as my one. It does not change the optimizers decision about
> the index or if an index at all is used. So I assume they
> hook into the same position where depending on the order by
> clause the sort node is added. And that is at the very end of
> the optimizer.
>
> What you describe above requires changes in upper levels of
> optimization. Doing that is far away from my knowledge about
> the optimizer. And some of your earlier statements let me
> think you aren't familiar enough with it too. We need at
> least help from others to do it well.
>
> I don't want to dive that deep into the optimizer. There was
> a far too long time where the rule system was broken and got
> out of sync with the parser/optimizer capabilities. I fixed
> many things in it for 6.4. My first priority now is, not to
> let such a situation come up again.
I agree. Another good thing is that the LIMIT thing will not require a
dump/reload, so it is a good candidate for a minor release.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026