Message-ID: <509BD33E.2030802@gmail.com>
Date: Thu, 08 Nov 2012 13:43:58 -0200
From: Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:10.0.10) Gecko/20121027 Icedove/10.0.10
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@2ndquadrant.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Merlin Moncure <mmoncure@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG
 9.2
References: <17866.1352229874@sss.pgh.pa.us> <50996583.2080703@gmail.com>
	<18371.1352231105@sss.pgh.pa.us>
	<CAHyXU0xRk0LCj6NYuTAUaWN2FDAWj+jHgH2niDAGtb1w4QT83w@mail.gmail.com>
	<509A42F9.6040403@gmail.com>
	<CAHyXU0wn4vftY2Q4yFZNLu9XNeRRjTUnMXKw-BmmvixJMMvohw@mail.gmail.com>
	<10569.1352307514@sss.pgh.pa.us> <509AD4C4.5070003@gmail.com>
	<6034.1352336282@sss.pgh.pa.us> <509BD01F.6030602@gmail.com>
	<20121108153845.GD7225@alvh.no-ip.org>
In-Reply-To: <20121108153845.GD7225@alvh.no-ip.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Em 08-11-2012 13:38, Alvaro Herrera escreveu:
> Rodrigo Rosenfeld Rosas escribió:
>> Em 07-11-2012 22:58, Tom Lane escreveu:
>>> Rodrigo Rosenfeld Rosas<rr.rosas@gmail.com>   writes:
>>>> Ok, I could finally strip part of my database schema that will allow you
>>>> to run the explain query and reproduce the issue.
>>>> There is a simple SQL dump in plain format that you can restore both on
>>>> 9.1 and 9.2 and an example EXPLAIN query so that you can see the
>>>> difference between both versions.
>>>> Please keep me up to date with regards to any progress. Let me know if
>>>> the commit above fixed this issue.
>>> AFAICT, HEAD and 9.2 branch tip plan this query a bit faster than 9.1
>>> does.
>> Great! What is the estimate for 9.2.2 release?
> Hasn't been announced, but you can grab a snapshot right now from
> ftp.postgresql.org if you want.

Thank you, Álvaro, but I prefer to use official Debian packages instead 
since they are easier to manage and more integrated to our OS.

For now I have rolled back to 9.1 this morning and it is working fine, 
so I don't have any rush. I just want an estimate to know when I should 
try upgrading 9.2 from experimental again after 9.2.2 is released.

Cheers,
Rodrigo.