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 –
-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
