Message-ID: <5127244D.4030101@gmail.com>
Date: Fri, 22 Feb 2013 11:54:53 +0400
From: Claude Speed <gta3user@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
	rv:17.0) Gecko/20130107 Thunderbird/17.0.2
MIME-Version: 1.0
To: Jeff Janes <jeff.janes@gmail.com>
CC: pgsql-bugs@postgresql.org
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
References: <5124D2BE.5090001@gmail.com>
	<CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com>
In-Reply-To: 
 <CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

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