Re: random_page_cost = 2.0 on Heroku Postgres

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Peter van Hardenberg <pvh(at)pvh(dot)ca>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: random_page_cost = 2.0 on Heroku Postgres
Date: 2012-02-10 01:29:10
Message-ID: CAOR=d=0W3dEzqEb=uuaXP_OoYxPC_0PSy4ZzefZF_BnCocopZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Feb 9, 2012 at 3:41 PM, Peter van Hardenberg <pvh(at)pvh(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2012-02-10 06:19:52 Re: timestamp with time zone
Previous Message Peter van Hardenberg 2012-02-09 22:41:34 Re: random_page_cost = 2.0 on Heroku Postgres