Postgres Pro
Downloads
Home   >   mailing lists

Re: random_page_cost = 2.0 on Heroku Postgres - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: random_page_cost = 2.0 on Heroku Postgres
Date
Msg-id CAOR=d=0W3dEzqEb=uuaXP_OoYxPC_0PSy4ZzefZF_BnCocopZA@mail.gmail.com
Whole thread Raw
In response to Re: random_page_cost = 2.0 on Heroku Postgres  (Peter van Hardenberg <pvh@pvh.ca>)
Responses Re: random_page_cost = 2.0 on Heroku Postgres  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view 
On Thu, Feb 9, 2012 at 3:41 PM, Peter van Hardenberg <pvh@pvh.ca> wrote:
> Hmm, perhaps we could usefully aggregate auto_explain output.

How about something where you run a site at random_page cost of x,
then y, then z and you do some aggregating of query times in each.  A
scatter plot should tell you lots.

pgsql-performance by date:

Previous
From: Peter van Hardenberg
Date:
Subject: Re: random_page_cost = 2.0 on Heroku Postgres
Next
From: Tom Lane
Date:
Subject: Re: timestamp with time zone