From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Date: Thu, 8 Nov 2012 12:38:45 -0300
Message-ID: <20121108153845.GD7225@alvh.no-ip.org> (raw)
In-Reply-To: <509BD01F.6030602@gmail.com>
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>
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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
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-performance@postgresql.org
Cc: alvherre@2ndquadrant.com, rr.rosas@gmail.com, tgl@sss.pgh.pa.us, mmoncure@gmail.com
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
In-Reply-To: <20121108153845.GD7225@alvh.no-ip.org>
* 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