| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Rodrigo Rosenfeld Rosas <rr(dot)rosas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 |
| Date: | 2012-11-08 15:38:45 |
| Message-ID: | 20121108153845.GD7225@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rodrigo Rosenfeld Rosas escribió:
> Em 07-11-2012 22:58, Tom Lane escreveu:
> >Rodrigo Rosenfeld Rosas<rr(dot)rosas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Rosenfeld Rosas | 2012-11-08 15:43:58 | Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 |
| Previous Message | Rodrigo Rosenfeld Rosas | 2012-11-08 15:30:39 | Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 |