Date: Thu, 8 Nov 2012 12:38:45 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Rodrigo Rosenfeld Rosas <rr.rosas@gmail.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
Message-ID: <20121108153845.GD7225@alvh.no-ip.org>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <509BD01F.6030602@gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Content-Transfer-Encoding: quoted-printable

Rodrigo Rosenfeld Rosas escribi=F3:
> 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 i=
f
> >>the commit above fixed this issue.
> >AFAICT, HEAD and 9.2 branch tip plan this query a bit faster than 9.1
> >does.
>=20
> 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.

--=20
=C1lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services