Re: Problem with planner choosing nested loop

From: Alex Solovey <a(dot)solovey(at)gmail(dot)com>
To: "Rodrigo E(dot) De León Plicet" <rdeleonp(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with planner choosing nested loop
Date: 2008-04-02 19:02:15
Message-ID: 47F3D837.10603@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The reduced database example has the same problem in EXPLAIN ANALYZE as
production one, here:

Seq Scan on bar (cost=0.00..393.07 rows=1 width=4) (actual
time=0.098..3.561 rows=24 loops=1)

That's why I posted the smallest dataset I could reproduce the problem with.

Rodrigo E. De León Plicet wrote:
>
> Then provide actual DDL plus the production EXPLAIN ANALYZE output and
> post it, maybe one of the Postgres gurus can help.
>
> Good luck.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2008-04-02 19:06:39 Re: Problem with planner choosing nested loop
Previous Message Rodrigo E. De León Plicet 2008-04-02 18:57:00 Re: Problem with planner choosing nested loop