Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: vincent.moreau@xxxxxxxxxxxxxx
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 13 Mar 2007 11:06:13 -0400
Cc: Michael Fuhr <mike@xxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to <vincent.moreau@xxxxxxxxxxxxxx> message dated "Tue, 13 Mar 2007 15:05:29 +0100"
In-reply-to: <45F6AFA9.4020804@xxxxxxxxxxxxxx>
References: <45F65EA3.1030706@xxxxxxxxxxxxxx> <20070313101117.GA98241@xxxxxxxxxxxxxxx> <45F686FA.2090909@xxxxxxxxxxxxxx> <20070313130945.GB4490@xxxxxxxxxxxxxx> <45F6A6F8.9090405@xxxxxxxxxxxxxx> <20070313134306.GC6715@xxxxxxxxxxxxxx> <45F6AFA9.4020804@xxxxxxxxxxxxxx>

<vincent.moreau@xxxxxxxxxxxxxx> 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

Follow-Ups:
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: vincent.moreau

References:
- Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: vincent.moreau
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: Michael Fuhr
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: vincent.moreau
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: Alvaro Herrera
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: vincent.moreau
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: Alvaro Herrera
- Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
  - From: vincent.moreau

Prev by Date: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Next by Date: Autocommit in libpq
Previous by thread: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Next by thread: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]