From: Tom Lane <tgl@sss.pgh.pa.us>
To: Patrice Beliveau <pbeliveau@avior.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimizing queries
Date: Tue, 08 Aug 2006 16:42:29 -0400
Message-ID: <13030.1155069749@sss.pgh.pa.us> (raw)
In-Reply-To: <44D8F0B8.2030804@avior.ca>
References: <44D8CE92.1080407@avior.ca>
<1155062399.20252.50.camel@state.g2switchworks.com>
<44D8F0B8.2030804@avior.ca>
Patrice Beliveau <pbeliveau@avior.ca> writes:
>>> SELECT * FROM TABLE
>>> WHERE TABLE.COLUMN1=something
>>> AND TABLE.COLUMN2=somethingelse
>>> AND function(TABLE.COLUMN3,TABLE.COLUMN4) > 0;
> I find out that the function process every row even if the row should be
> rejected as per the first or the second condition.
> ... I'm using version 8.1.3
PG 8.1 will not reorder WHERE clauses for a single table unless it has
some specific reason to do so (and AFAICT no version back to 7.0 or so
has done so either...) So there's something you are not telling us that
is relevant. Let's see the exact table schema (psql \d output is good),
the exact query, and EXPLAIN output for that query.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, pbeliveau@avior.ca
Subject: Re: Optimizing queries
In-Reply-To: <13030.1155069749@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox