Re: random_page_cost = 2.0 on Heroku Postgres
- To: Peter van Hardenberg <pvh@xxxxxx>
- Subject: Re: random_page_cost = 2.0 on Heroku Postgres
- From: Josh Berkus <josh@xxxxxxxxxxxx>
- Date: Fri, 10 Feb 2012 17:40:32 -0800
- Cc: Jeff Janes <jeff.janes@xxxxxxxxx>, Scott Marlowe <scott.marlowe@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
- In-reply-to: <CAAcg=kW-FOzojjPnC7w7EXgZxmr9Quu_4zDDd4TBDSs_wfNDmg@mail.gmail.com>
- Organization: PostgreSQL Experts Inc.
- 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> <4F3570E2.2070301@agliodbs.com> <CAAcg=kW-FOzojjPnC7w7EXgZxmr9Quu_4zDDd4TBDSs_wfNDmg@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
Peter,
> We've funded some work by Peter Geoghegan to make pg_stat_statements
> more useful, but the patch is currently sitting in the commitfest in
> need of a champion. I'd very much like to see it landed.
Ok, let me review it then ...
> Between that work, 9.2, and Dimitri's extension whitelist module,
> pg_stat_statements should be usefully installable by everyone. We'd
> seriously consider installing it by default, but that would make us
> Not Vanilla, which is something we avoid very diligently.
Bummer. You can get why this would be useful for autotuning, though, yes?
--
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]