On Tue, 2007-10-09 at 15:09 -0500, Kevin Grittner wrote:
> I have a situation where a query is running much slower than I would
> expect. The ANALYZE showed that it is hashing some information which
> is rarely needed. When I set enable_hashjoin = off for the
> connection the query run in 1/1000 the time.
Can you confirm the two queries give identical outputs? It isn't clear
to me why the second sort is (never executed) in your second plan, which
I would only expect to see for an inner merge join.
Can you show the details for ControlRecord also.
In response to
pgsql-performance by date
|Next:||From: Tomáš Vondra||Date: 2007-10-10 10:41:49|
|Subject: Re: SQL Monitoring|
|Previous:||From: Marcin Stępnicki||Date: 2007-10-10 05:25:45|
|Subject: Re: Shared Buffer setting in postgresql.conf|