"Peterson, Bjorn" <[EMAIL PROTECTED]> writes:
>> That's what it's there for ... but it would be useful to look into why
>> the planner gets it so wrong without that hint. Could we see EXPLAIN
>> ANALYZE both ways?
> Below is my query and the output of EXPLAIN - I was not able to run EXPLAIN
> ANA
-Original Message-
>From: Tom Lane [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 01, 2005 10:37 AM
>To: Peterson, Bjorn
>Cc: pgsql-performance@postgresql.org
>Subject: Re: [PERFORM] enable_XXX options
>
>"Peterson, Bjorn" <[EMAIL PROTECTED]> writes
"Peterson, Bjorn" <[EMAIL PROTECTED]> writes:
> I have a query in my application that takes an unreasonable amount of time
> to complete (>4.5 hours execution time). After reviewing the EXPLAIN and
> EXPLAIN ANALYZE output for that and similar queries, my colleagues and I
> determined that turnin
I have a query in my application that takes an unreasonable
amount of time to complete (>4.5 hours execution time). After
reviewing the EXPLAIN and EXPLAIN ANALYZE output for that and similar queries,
my colleagues and I determined that turning off the enable_nestloop option
might help –