From: Marcos Ortiz Valmaseda <mlortiz@uci.cu>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-performance@postgresql.org, Scott Marlowe <scott.marlowe@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>
Subject: Re: random_page_cost = 2.0 on Heroku Postgres
Date: Thu, 09 Feb 2012 00:41:43 -0430
Message-ID: <4F33558F.1020504@uci.cu> (raw)
In-Reply-To: <00198dd656e4228cb66aa53a68ca0e14@biglumber.com>
References: <00198dd656e4228cb66aa53a68ca0e14@biglumber.com>
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.comhttp://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.cuhttp://justiciaparaloscinco.wordpress.com
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: mlortiz@uci.cu, greg@turnstep.com, scott.marlowe@gmail.com, josh@agliodbs.com
Subject: Re: random_page_cost = 2.0 on Heroku Postgres
In-Reply-To: <4F33558F.1020504@uci.cu>
* 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