Re: new BUG: "postgresql 9.2.3: very long query time"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: new BUG: "postgresql 9.2.3: very long query time"
Дата
Msg-id 2933.1361636724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на new BUG: "postgresql 9.2.3: very long query time"  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Jeff Janes <jeff.janes@gmail.com> writes:
> On Friday, February 22, 2013, Tom Lane wrote:
>> Try increasing from_collapse_limit to 11 or more.

> I've increased it to 20 and still no luck.

Huh --- that improved the results for me.

> I've stripped it down to this:

I'm not sure if that's exactly the same issue the OP is hitting, but
will take a look at it.  Thanks for the simpler test case.

            regards, tom lane

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: new BUG: "postgresql 9.2.3: very long query time"
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #7903: EAN13s are shown ISBN values