Re: after vacuum analyze, explain still wrong

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: after vacuum analyze, explain still wrong
Date: 2009-06-23 11:32:25
Message-ID: 2f4958ff0906230432w3ce2303fjbc6365850cb52f2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 23, 2009 at 10:54 AM, Sim Zacks<sim(at)compulab(dot)co(dot)il> wrote:
> Sim Zacks wrote:
>> Grzegorz Jaśkiewicz wrote:
>>> give us postgresql version as well, maybe show query and at least table layout.
>>>
>>
> The queries look like (The one I'm trying to run is the last one, which
> is based on all the previous ones).:
>

oh dear, this is big.
I know planner isn't good in propagating rowcount estimations up the
plan. So maybe that's it. But I'll wait for hackers-folk to reply.

--
GJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-06-23 11:47:55 Re: Please suggest me on my table design (indexes!)
Previous Message DelGurth 2009-06-23 10:58:39 Re: Cache lookup failed for type 70385664