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

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.