pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Peter van Hardenberg <pvh@pvh.ca>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: random_page_cost = 2.0 on Heroku Postgres
Date: Fri, 10 Feb 2012 11:32:50 -0800
Message-ID: <4F3570E2.2070301@agliodbs.com> (raw)
In-Reply-To: <CAAcg=kXOiAi66tzP6hdFTSECjvKjLx65jUcMYQ1g3j4XdzOWDw@mail.gmail.com>
References: <CAAcg=kWsjAXRNt0sSjsF-Ft+NfZi30Owa=-PGvghSJ6A0jeVYQ@mail.gmail.com>
	<4F331866.7070401@agliodbs.com>
	<CAOR=d=2QNts+9tS6SYcgKhSM56MbJPR2Js=B9YWfGehUVR+i+Q@mail.gmail.com>
	<CAAcg=kXzU8BDySsJKuBPLXRn7opoPX33fMcxNL33GCZgOF98rQ@mail.gmail.com>
	<CAOR=d=3CqkNHvznRggv5HvY8C=Pex1EO9XQ2giNKX6VnL8LTyw@mail.gmail.com>
	<CAMkU=1xnK+HiW4cZS_qy0vMJeDXFgf9+XDuz0uVX+iNCukejqA@mail.gmail.com>
	<CAAcg=kXOiAi66tzP6hdFTSECjvKjLx65jUcMYQ1g3j4XdzOWDw@mail.gmail.com>

On 2/9/12 2:41 PM, Peter van Hardenberg wrote:
> Hmm, perhaps we could usefully aggregate auto_explain output.

The other option is to take a statistical approach.  After all, what you
want to do is optimize average response times across all your user's
databases, not optimize for a few specific queries.

So one thought would be to add in pg_stat_statements to your platform
... something I'd like to see Heroku do anyway.  Then you can sample
this across dozens (or hundreds) of user databases, each with RPC set to
a slightly different level, and aggregate it into a heat map.

That's the way I'd do it, anyway.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



view thread (25+ messages)  latest in thread

Message-ID: <4F3570E2.2070301@agliodbs.com>
Permalink:  ../4F3570E2.2070301@agliodbs.com/
Also on:    postgresql.org/message-id/4F3570E2.2070301@agliodbs.com

 · 

reply
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: josh@agliodbs.com, pvh@pvh.ca, jeff.janes@gmail.com, scott.marlowe@gmail.com
  Subject: Re: random_page_cost = 2.0 on Heroku Postgres
  In-Reply-To: <4F3570E2.2070301@agliodbs.com>

* 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