Re: Strange behaviour with a query

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Strange behaviour with a query
Дата
Msg-id dcc563d10904170329x2a37b01die043e0b5259cc82f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Strange behaviour with a query  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Strange behaviour with a query  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
On Fri, Apr 17, 2009 at 4:17 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, Apr 17, 2009 at 3:00 AM, Iñigo Martinez Lasala
> <imartinez@vectorsf.com> wrote:
>> Hi everybody again.
>>
>> Deleting rel_dis_can_fk index has solved the problem! But.... why??
>
> Hard to say without explain analyze output.
>

I'd hazard a guess that you're getting a lot more rows back from the
bitmap scan of rel_dis_can_fk than the query planner expects.  But
that's just a guess.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Strange behaviour with a query
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Strange behaviour with a query