Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with planner choosing nested loop - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Problem with planner choosing nested loop
Date
Msg-id pu63v0xeio.fsf@srv.protecting.net
Whole thread Raw
In response to Problem with planner choosing nested loop  (Alex Solovey <a.solovey@gmail.com>)
Responses Re: Problem with planner choosing nested loop  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
In article <a55915760804021107h4410dd93m33a6f94e28a83a2b@mail.gmail.com>,
"Rodrigo E. De León Plicet" <rdeleonp@gmail.com> writes:

> On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <a.solovey@gmail.com> wrote:
>> ... I have no idea how it could be fixed.

> - CREATE INDEX xifoo ON foo(bar_id);
> - ANALYZE;
> - Retry.

A compound index
  CREATE INDEX xifoo2 ON foo (foo_a, bar_id)
might be more worthwhile.

pgsql-general by date:

Previous
From: Alex Solovey
Date:
Subject: Re: Problem with planner choosing nested loop
Next
From: "Richard Broersma"
Date:
Subject: Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'