Re: Any way to speed this up? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Any way to speed this up?
Date
Msg-id 3303.1112889874@sss.pgh.pa.us
Whole thread Raw
In response to Any way to speed this up?  ("Joel Fradkin" <jfradkin@wazagua.com>)
Responses Re: Any way to speed this up?  ("Joel Fradkin" <jfradkin@wazagua.com>)
List pgsql-performance
"Joel Fradkin" <jfradkin@wazagua.com> writes:
> Running this explain on windows box, but production on linux both 8.0.1

Are you using any nondefault optimizer settings?  The vast bulk of the
time is going into the indexscan on tblassociate (almost 42 out of the
48 seconds), and I'm a bit surprised it didn't choose a seqscan and sort
instead.  Or even more likely, forget the merge joins altogether and use
hash joins --- the other tables are plenty small enough to fit in hash
tables.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
Next
From: Tom Lane
Date:
Subject: Re: Any way to speed this up?