Skip site navigation (1) Skip section navigation (2)

Re: Really dumb planner decision

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Really dumb planner decision
Date: 2009-04-16 10:48:19
Message-ID: 2f4958ff0904160348y4e05defam92b767ca396e0d70@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Apr 16, 2009 at 11:37 AM, Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
>
> I have a query that is executed really badly by Postgres. It is a nine table
> join, where two of the tables are represented in a view. If I remove one of
> the tables from the query, then the query runs very quickly using a
> completely different plan.

And what happens if you execute that view alone, with WHERE .. just
like it would be a part of the whole query? ((id = 1267676))


-- 
GJ

In response to

Responses

pgsql-performance by date

Next:From: Grzegorz JaśkiewiczDate: 2009-04-16 11:16:13
Subject: Re: Really dumb planner decision
Previous:From: Matthew WakelingDate: 2009-04-16 10:37:29
Subject: Really dumb planner decision

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group