Re: after vacuum analyze, explain still wrong

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: after vacuum analyze, explain still wrong
Дата
Msg-id 2f4958ff0906230432w3ce2303fjbc6365850cb52f2e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: after vacuum analyze, explain still wrong  (Sim Zacks <sim@compulab.co.il>)
Ответы Re: after vacuum analyze, explain still wrong  (Greg Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: Sim Zacks
Дата:
Сообщение: Re: after vacuum analyze, explain still wrong
Следующее
От: DaNieL
Дата:
Сообщение: Please suggest me on my table design (indexes!)