Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom, do we have a TODO item here?
>
> I'm not excited about it; it seems a weird case and there's a simple
> query change to get the right thing to happen. AFAICS we'd have to
> expend a lot of planner cycles to detect this case, an
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom, do we have a TODO item here?
I'm not excited about it; it seems a weird case and there's a simple
query change to get the right thing to happen. AFAICS we'd have to
expend a lot of planner cycles to detect this case, and most of the
time those cyc
Brian McCane wrote:
> On Thu, 14 Feb 2002, Tom Lane wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > In fact, I am unsure why you are specifying the primary column in the
> > > ORDER BY anyway if you know it will be a single value, except perhaps to
> > > try and get it to use the ind
Here is another peeve
Having to specify the type of a constant in a SELECT DISTINCT 'foo'...
I which I had more spare time to contribute...
Jean-Luc
Tom Lane wrote:
>
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > In fact, I am unsure why you are specifying the primary column in the
> > ORD
On Thu, 14 Feb 2002, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > In fact, I am unsure why you are specifying the primary column in the
> > ORDER BY anyway if you know it will be a single value, except perhaps to
> > try and get it to use the index, right?
>
> Exactly. The sor
Bruce Momjian <[EMAIL PROTECTED]> writes:
> In fact, I am unsure why you are specifying the primary column in the
> ORDER BY anyway if you know it will be a single value, except perhaps to
> try and get it to use the index, right?
Exactly. The sort ordering of the index is (col1,col2) while the
Tom Lane wrote:
> Brian McCane <[EMAIL PROTECTED]> writes:
> > CREATE INDEX foo_index ON foo (bazid, score desc) ;
>
> > Which would be exactly what I want, and would complete in a split second.
> > Instead, this thing runs FOREVER (okay, it just seems that way to my
> > client :). Is there any
Brian McCane <[EMAIL PROTECTED]> writes:
> Then I tried your way (after I realized I had already selected a
> specific bazid so it didn't matter if it was descending :),
Yup, that's the little flash of insight that the planner is incapable
of having :-(
regards, tom lane
Brian McCane <[EMAIL PROTECTED]> writes:
> CREATE INDEX foo_index ON foo (bazid, score desc) ;
> Which would be exactly what I want, and would complete in a split second.
> Instead, this thing runs FOREVER (okay, it just seems that way to my
> client :). Is there any way to get the equivalent in
On Thu, 14 Feb 2002, Tom Lane wrote:
> Brian McCane <[EMAIL PROTECTED]> writes:
> > CREATE INDEX foo_index ON foo (bazid, score desc) ;
>
> > Which would be exactly what I want, and would complete in a split second.
> > Instead, this thing runs FOREVER (okay, it just seems that way to my
> > clie
10 matches
Mail list logo
