Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: random_page_cost = 2.0 on Heroku Postgres
Date
Msg-id CAMkU=1x=p2qSssS65PFrD+8dWhae01x8xxbeV30cZJF8aOyGZQ@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
List pgsql-performance
Tree view 
On Thu, Feb 9, 2012 at 2:41 PM, Peter van Hardenberg <pvh@pvh.ca> wrote:

> Hmm, perhaps we could usefully aggregate auto_explain output.

By the time you realize the query is running long, it is too late to
start analyzing it.  And without analyzing it, you probably can't get
the information you need.

Maybe with the timing = off feature,it would might make sense to just
preemptively analyze everything.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: CSS
Date:
Subject: Re: rough benchmarks, sata vs. ssd
Next
From: Peter van Hardenberg
Date:
Subject: Re: random_page_cost = 2.0 on Heroku Postgres