Re: query optimization Anyone know a better way to run this query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Blood" <david(at)matraex(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query optimization Anyone know a better way to run this query
Date: 2002-02-22 02:13:08
Message-ID: 13025.1014343988@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Blood" <david(at)matraex(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-22 02:43:53 Re: PL/pgSQL Memory Management?
Previous Message Tom Lane 2002-02-22 02:01:33 Re: Follow Up: How to properly build postgresql version 7.2 on Unix Platforms?