Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 86AF9E267C2 for ; Thu, 9 Feb 2012 01:42:08 -0400 (AST) Received: from ns3.uci.cu ([200.55.140.180] helo=mx3.uci.cu) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1RvMle-0005Gt-BZ for pgsql-performance@postgresql.org; Thu, 09 Feb 2012 05:42:08 +0000 Received: (qmail 13740 invoked by uid 507); 9 Feb 2012 05:41:36 -0000 Received: from 10.0.0.188 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.188):. Processed in 0.905171 secs); 09 Feb 2012 05:41:36 -0000 Received: from unknown (HELO ucimail5.uci.cu) (10.0.0.188) by 0 with SMTP; 9 Feb 2012 05:41:35 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail5.uci.cu (Postfix) with ESMTP id 690961103F8 for ; Thu, 9 Feb 2012 00:41:35 -0500 (CST) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail5.uci.cu ([127.0.0.1]) by localhost (ucimail5.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id iWYyNkCYadd4 for ; Thu, 9 Feb 2012 00:41:33 -0500 (CST) Received: by ucimail5.uci.cu (Postfix, from userid 101) id E7DA81103EC; Thu, 9 Feb 2012 00:41:33 -0500 (CST) Received: from [10.8.26.2] (synet2011.uci.cu [10.8.26.2]) (Authenticated sender: mlortiz@uci.cu) by ucimail5.uci.cu (Postfix) with ESMTPSA id CFECA1103E1; Thu, 9 Feb 2012 00:41:33 -0500 (CST) Message-ID: <4F33558F.1020504@uci.cu> Date: Thu, 09 Feb 2012 00:41:43 -0430 From: Marcos Ortiz Valmaseda User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:8.0) Gecko/20111115 Thunderbird/8.0 MIME-Version: 1.0 To: Greg Sabino Mullane CC: pgsql-performance@postgresql.org, Scott Marlowe , Josh Berkus Subject: Re: random_page_cost = 2.0 on Heroku Postgres References: <00198dd656e4228cb66aa53a68ca0e14@biglumber.com> In-Reply-To: <00198dd656e4228cb66aa53a68ca0e14@biglumber.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/72 X-Sequence-Number: 46244 On 09/02/12 00:09, Greg Sabino Mullane wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > > >> You can execute several queries with the three different values provided >> by Scott and Josh. >> - SET random_page_cost = 2.0 >> First execution of the queries with EXPLAIN ANALYZE >> - SET random_page_cost = 1.4 >> Second execution of the queries with EXPLAIN ANALYZE >> - SET random_page_cost = 1.2 >> Second execution of the queries with EXPLAIN ANALYZE > Well, such a tool would ideally be smarter than that, such that > you would run EXPLAIN and compare to the previous plan and > only run EXPLAIN ANALYZE if the plan changed. One could even > decrement rpc slowly and find out at one points it changes, > which would be more interesting than testing arbitrary numbers. > Would lead to some really sweet graphs as well. :) > Well, the MyYearBook.com´s guys built something seemed called Posuta, I don´t know is this project is alive, but we can ask to them (michael.glaesemann@myyearbook.com). http://area51.myyearbook.com Posuta can be a starting point for it. It uses Ruby and Clojure for core functionalities, jQuery/Flot for graphics, -- Marcos Luis Ortíz Valmaseda Sr. Software Engineer (UCI) http://marcosluis2186.posterous.com http://www.linkedin.com/in/marcosluis2186 Twitter: @marcosluis2186 Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU! http://www.antiterroristas.cu http://justiciaparaloscinco.wordpress.com