Postgres Pro
Downloads
Home   >   mailing lists

Re: query optimization Anyone know a better way to run this query - Mailing list pgsql-general

From Tom Lane
Subject Re: query optimization Anyone know a better way to run this query
Date
Msg-id 13025.1014343988@sss.pgh.pa.us
Whole thread Raw
In response to query optimization Anyone know a better way to run this query  ("David Blood" <david@matraex.com>)
List pgsql-general
Tree view 
"David Blood" <david@matraex.com> writes:
> Anyone know a better way to run this query to make it faster.

> SET ENABLE_SEQSCAN TO OFF;

Are you sure that's a good idea?  The plan looks to me like it would be
better off *without* indexscans.

How many rows are you expecting to get out of the join?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Follow Up: How to properly build postgresql version 7.2 on Unix Platforms?
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: Createdb problems