Re: Expensive where clause

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Keith Worthington <keithw(at)narrowpathinc(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Expensive where clause
Date: 2005-02-19 05:55:29
Message-ID: 20050218215121.Y48429@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-02-19 06:40:45 Re: Expensive where clause
Previous Message Keith Worthington 2005-02-19 03:27:49 Expensive where clause