Re: Slow query. Any way to speed up?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query. Any way to speed up?
Date: 2006-01-06 05:07:57
Message-ID: 18083.1136524077@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Patrick Hatcher <PHatcher(at)macys(dot)com> writes:
> The following SQL takes 4+ mins to run. I have indexes on all join fields
> and I've tried rearranging the table orders but haven't had any luck.

Please show EXPLAIN ANALYZE output, not just EXPLAIN. It's impossible
to tell whether the planner is making any wrong guesses when you can't
see the actual times/rowcounts ...

(BTW, 7.4 is looking pretty long in the tooth.)

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy 2006-01-06 09:21:31 Re: Improving Inner Join Performance
Previous Message Jim C. Nasby 2006-01-06 03:14:21 Re: Help in avoiding a query 'Warm-Up' period/shared buffer