Re: random_page_cost = 2.0 on Heroku Postgres
- To: pgsql-performance@xxxxxxxxxxxxxx
- Subject: Re: random_page_cost = 2.0 on Heroku Postgres
- From: Josh Berkus <josh@xxxxxxxxxxxx>
- Date: Wed, 08 Feb 2012 16:50:46 -0800
- In-reply-to: <CAAcg=kWsjAXRNt0sSjsF-Ft+NfZi30Owa=-PGvghSJ6A0jeVYQ@mail.gmail.com>
- Organization: PostgreSQL Experts Inc.
- References: <CAAcg=kWsjAXRNt0sSjsF-Ft+NfZi30Owa=-PGvghSJ6A0jeVYQ@mail.gmail.com>
- User-agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.24) Gecko/20111103 Lightning/1.0b2 Thunderbird/3.1.16
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.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Home]
[Yosemite]