Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVp5A-0007ap-FC for pgsql-performance@postgresql.org; Tue, 06 Nov 2012 19:45:08 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVp58-0001VS-SZ for pgsql-performance@postgresql.org; Tue, 06 Nov 2012 19:45:07 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id qA6Jj5qd018372; Tue, 6 Nov 2012 14:45:05 -0500 (EST) From: Tom Lane To: Rodrigo Rosenfeld Rosas cc: Merlin Moncure , pgsql-performance@postgresql.org Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 In-reply-to: <50996583.2080703@gmail.com> References: <509944DE.6020400@gmail.com> <5099525B.5070909@gmail.com> <50995D7C.9020108@gmail.com> <17866.1352229874@sss.pgh.pa.us> <50996583.2080703@gmail.com> Comments: In-reply-to Rodrigo Rosenfeld Rosas message dated "Tue, 06 Nov 2012 17:31:15 -0200" Date: Tue, 06 Nov 2012 14:45:05 -0500 Message-ID: <18371.1352231105@sss.pgh.pa.us> X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201211/71 X-Sequence-Number: 48437 Rodrigo Rosenfeld Rosas writes: > Em 06-11-2012 17:24, Tom Lane escreveu: >> Can you put together a self-contained test case to duplicate these >> results? I'm prepared to believe there's some sort of planner >> regression involved here, but we'll never find it without a test case. > I'd love to, but I'm afraid I won't have time to do this any time soon. > Maybe on Sunday. I'll see if I can get a script to generate the database > on Sunday and hope for it to replicate the issue. > Would you mind if I coded it using Ruby? (can you run Ruby code in your > computer?) I mean, for filling with some sample data. No objection. regards, tom lane