Re: incorrect row estimates for primary key join

Поиск
Список
Период
Сортировка
От Marcin Mańk
Тема Re: incorrect row estimates for primary key join
Дата
Msg-id CAK61fk5pLO18DwtkCQaMNsrELLWxp=5g6r5RWr09RVG2M34tYA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: incorrect row estimates for primary key join  (Ben <midfield@gmail.com>)
Ответы Re: incorrect row estimates for primary key join  (Ben <midfield@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Wed, Jun 26, 2013 at 2:29 AM, Ben <midfield@gmail.com> wrote:

> shouldn't an index scan definitely be fastest here?  you don't need to touch the whole table or index.  maybe there
somethingi have misconfigured here? 
>

How about you try increasing work_mem ? I think a hash join may be the
best plan here, and it won't get chosen with low work_mem .

Regards
Marcin Mańk

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Weird, bad 0.5% selectivity estimate for a column equal to itself
Следующее
От: Ben
Дата:
Сообщение: Re: incorrect row estimates for primary key join