Postgres Pro
Downloads
Home   >   mailing lists

Re: Expensive where clause - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Expensive where clause
Date
Msg-id 20050218215121.Y48429@megazone.bigpanda.com
Whole thread Raw
In response to Expensive where clause  ("Keith Worthington" <keithw@narrowpathinc.com>)
Responses Re: Expensive where clause  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
Tree view 
On Fri, 18 Feb 2005, Keith Worthington wrote:

> I have been working on a SQL statement that contains a WHERE clause of the
> form WHERE column1 > column2.  The query runs pretty quickly (285ms) without
> the WHERE clause but slows to a relative crawl (5850ms) when it is included.
> Anu suggestions on how to improve the performance would be greatly appreciated.

Explain analyze output for the query with and without the clause would
probably be useful for analysis.

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Expensive where clause
Next
From: "Keith Worthington"
Date:
Subject: Re: Expensive where clause