| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org>, Greg Smith <greg(at)2ndQuadrant(dot)com> |
| Subject: | Re: PostgreSQL settings for running on an SSD drive |
| Date: | 2013-06-20 21:23:06 |
| Message-ID: | 51C372BA.1040807@optionshouse.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2013-06-20 21:32:34 | Re: PostgreSQL settings for running on an SSD drive |
| Previous Message | Josh Berkus | 2013-06-20 20:32:14 | Re: PostgreSQL settings for running on an SSD drive |