On 2/7/12 4:59 PM, Peter van Hardenberg wrote:
> Per the thread from last month, I've updated the default
> random_page_cost on Heroku Postgres to reduce the expected cost of a
> random_page on all new databases.
This is because Heroku uses AWS storage, which has fast seeks but poor
throughput compared to internal disk on a standard system, BTW.
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2012-02-09 01:39:14|
|Subject: Re: random_page_cost = 2.0 on Heroku Postgres|
|Previous:||From: Kevin Grittner||Date: 2012-02-08 23:41:06|
|Subject: Re: index scan forward vs backward = speed
difference of 357X slower!|