Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query. Any way to speed up? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow query. Any way to speed up?
Date
Msg-id 18083.1136524077@sss.pgh.pa.us
Whole thread Raw
In response to Slow query. Any way to speed up?  (Patrick Hatcher <PHatcher@macys.com>)
Responses Re: Slow query. Any way to speed up?  (Patrick Hatcher <PHatcher@macys.com>)
List pgsql-performance
Tree view 
Patrick Hatcher <PHatcher@macys.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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Help in avoiding a query 'Warm-Up' period/shared buffer
Next
From: "Andy"
Date:
Subject: Re: Improving Inner Join Performance