Postgres Pro
Downloads
Home   >   mailing lists

Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Date
Msg-id 2335.1173798373@sss.pgh.pa.us
Whole thread Raw
In response to Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3  (<vincent.moreau@leroymerlin.fr>)
Responses Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3  (<vincent.moreau@leroymerlin.fr>)
List pgsql-performance
Tree view 
<vincent.moreau@leroymerlin.fr> writes:
> I was able to improve response time by seting enable_seqscan to off

enable_nestloop = off would probably be a saner choice, at least for
this particular query.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Next
From: "Dengler, Michael"
Date:
Subject: Autocommit in libpq