Re: after vacuum analyze, explain still wrong - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: after vacuum analyze, explain still wrong
Date
Msg-id 2f4958ff0906230432w3ce2303fjbc6365850cb52f2e@mail.gmail.com
Whole thread Raw
In response to Re: after vacuum analyze, explain still wrong  (Sim Zacks <sim@compulab.co.il>)
Responses Re: after vacuum analyze, explain still wrong
List pgsql-general
On Tue, Jun 23, 2009 at 10:54 AM, Sim Zacks<sim@compulab.co.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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: after vacuum analyze, explain still wrong
Next
From: DaNieL
Date:
Subject: Please suggest me on my table design (indexes!)