Re: faster SELECT - Mailing list pgsql-general

From Tom Lane
Subject Re: faster SELECT
Date
Msg-id 3664.1078758181@sss.pgh.pa.us
Whole thread Raw
In response to faster SELECT  (sferriol <sylvain.ferriol@imag.fr>)
List pgsql-general
sferriol <sylvain.ferriol@imag.fr> writes:
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
> 1 and 2 will use the same cpu time or not ?

They'll generate the same query plan, except possibly for the evaluation
order of a and b (assuming that those end up attached to the same plan
node in the first place).  What that means for CPU time would depend on
what a and b are.

What are you trying to accomplish, exactly?  Your question is
essentially useless to ask or answer as it stands, so you'll
need to readjust your thinking.

            regards, tom lane

pgsql-general by date:

Previous
From: Mimi Siu
Date:
Subject: Binary Large object
Next
From: Tom Lane
Date:
Subject: Re: postmaster freeze