Em 07-11-2012 14:58, Tom Lane escreveu:
Merlin Moncure<mmoncure@xxxxxxxxx> writes:On Wed, Nov 7, 2012 at 5:16 AM, Rodrigo Rosenfeld Rosas <rr.rosas@xxxxxxxxx> wrote:This was a great guess! Congrats, Merlin:Heh -- that was tom's guess, not mine. What this does is confirm the planner regression and that elevates the importance of Tom's request to get sample data so we (he) can fix it.Well, the fact that it's a planner runtime problem and not a quality-of-plan problem is new information (I'd been assuming the latter). Given that, it's possible it's already fixed: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ca2d6a6cef5740b29406980eb8d21d44da32634b but I'd still want to see a test case to be sure. In any case, it's not clear what's the critical difference between the "fast" and "slow" versions of the query. regards, tom lane
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.
Thanks in advance, Rodrigo.
Attachment:
use_case.tar.bz2
Description: application/tbz
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
