Re: How to use index in WHERE int = float

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to use index in WHERE int = float
Date: 2008-11-06 00:13:37
Message-ID: 5081.1225930417@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <kobruleht2(at)hot(dot)ee> writes:
> As you see simply removing constant expression
> '0' or
> produces different query plan which is much faster for large amoutnts of
> data.

The IN-pullup code runs before constant-simplification does, so it
doesn't see that as a simple join condition.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2008-11-06 00:21:06 Re: Are there plans to add data compression feature to postgresql?
Previous Message Joshua D. Drake 2008-11-05 23:53:18 Re: Read only access, via functions only