From: Shaun Thomas <sthomas@optionshouse.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Cc: Greg Smith <greg@2ndQuadrant.com>
Subject: Re: PostgreSQL settings for running on an SSD drive
Date: Thu, 20 Jun 2013 16:23:06 -0500
Message-ID: <51C372BA.1040807@optionshouse.com> (raw)
In-Reply-To: <51C366CE.10206@agliodbs.com>
References: <51C35E6C.1090705@consistentstate.com>
<51C36256.6040502@optionshouse.com>
<WM!b9e5afbe8d527efb5c0f49ce7515ef211125a953db249e1e3ff58e04ad0791f3381fd39085635a2bb537ff66f740d4f2!@asav-1.01.com>
<51C366CE.10206@agliodbs.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 06/20/2013 03:32 PM, Josh Berkus wrote:
> Did you compare setting RPC to 1.0 vs. setting it to 1.1, or something
> else just slightly higher than SPC?
Yes, actually. My favored setting when we were on 8.3 was 1.5. But
something with the planner changed pretty drastically when we went to
9.1, and we were getting some really bad query plans unless we
*strongly* suggested RPC was cheap. I was afraid I'd have to go lower,
but 1 seemed to do the trick.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: sthomas@optionshouse.com, josh@agliodbs.com, greg@2ndQuadrant.com
Subject: Re: PostgreSQL settings for running on an SSD drive
In-Reply-To: <51C372BA.1040807@optionshouse.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