Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: vincent(dot)moreau(at)leroymerlin(dot)fr
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Date: 2007-03-13 13:43:06
Message-ID: 20070313134306.GC6715@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

vincent(dot)moreau(at)leroymerlin(dot)fr wrote:
> Here it is :
>
> CCM=# SHOW enable_mergejoin;
> enable_mergejoin
> ------------------
> on
> (1 row)

Sorry, my question was more general. Do you have _any_ of the planner
types disabled? Try also enable_indexscan, etc; maybe

select * from pg_settings where name like 'enable_%';

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message vincent.moreau 2007-03-13 14:04:49 Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Previous Message James Riordan 2007-03-13 13:36:47 Dispatch-Merge pattern