From: Claude Speed <gta3user@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
Date: Fri, 22 Feb 2013 11:54:53 +0400
Message-ID: <5127244D.4030101@gmail.com> (raw)
In-Reply-To: <CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com>
References: <5124D2BE.5090001@gmail.com>
<CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: gta3user@gmail.com, jeff.janes@gmail.com
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
In-Reply-To: <5127244D.4030101@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox