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

Поиск
Список
Период
Сортировка
От Claude Speed
Тема Re: new BUG: "postgresql 9.2.3: very long query time"
Дата
Msg-id 5127244D.4030101@gmail.com
обсуждение исходный текст
Ответ на Re: new BUG: "postgresql 9.2.3: very long query time"  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
21.02.2013 21:25, Jeff Janes пишет:
> On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed <gta3user@gmail.com> wrote:
>> Hi all,
>>
>> Postgresql 9.2.3 is processing my query is much longer than Postgresql
>> 9.1.8:
>> Postgresql 9.1.8 - 2292 ms
>> Postgresql 9.2.3 - 163336 ms
>>
>> I provided my query in attach and the database dump too,
>> this bug is reproducible.
>>
>> Operating system: Gentoo x86_64 Linux 2.6.36
> The slowness was introduced with this:
>
> commit e2fa76d80ba571d4de8992de6386536867250474
> Author: Tom Lane <tgl@sss.pgh.pa.us>
> Date:   Fri Jan 27 19:26:38 2012 -0500
>
>      Use parameterized paths to generate inner indexscans more flexibly.
>
>
> Do you know of simpler queries that also exhibits this behavior?  It
> would certainly make analysis of the issue easier.
>
>
> Cheers,
>
> Jeff
We was trying to find simple query, sadly unlucky. Only this query is
reproducible.

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

Предыдущее
От: Jov
Дата:
Сообщение: Re: BUG #7899: allow key word as alias in subquery but Can't reference it in outer query
Следующее
От: amutu@amutu.com
Дата:
Сообщение: BUG #7899: allow key word as alias in subquery but Can't reference it in outer query