Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-07-18 Thread Shaun Thomas
On 07/17/2013 09:04 PM, Greg Smith wrote: I'm working on a completely replacement of that guide, one that actually gives out a full set of advice. Right now I'm between their product cycles, I'm expecting new hardware again here soon. Me too. It's interesting that they seem to be focusing mor

Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-07-17 Thread Greg Smith
On 6/20/13 4:32 PM, Josh Berkus wrote: First, cc'ing Greg Smith to see if he can address this with the Fusion folks so that they stop giving out a bad guide. I'm working on a completely replacement of that guide, one that actually gives out a full set of advice. Right now I'm between their pr

Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-06-20 Thread Andrew Dunstan
On 06/20/2013 05:23 PM, Shaun Thomas wrote: 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 cha

Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-06-20 Thread Shaun Thomas
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,

Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-06-20 Thread Josh Berkus
Folks, First, cc'ing Greg Smith to see if he can address this with the Fusion folks so that they stop giving out a bad guide. On 06/20/2013 01:13 PM, Shaun Thomas wrote: > On 06/20/2013 02:56 PM, CS DBA wrote: > >> They have a PostgreSQL setup guide from Fusion recommending the >> following sett

Re: [PERFORM] PostgreSQL settings for running on an SSD drive

2013-06-20 Thread Shaun Thomas
On 06/20/2013 02:56 PM, CS DBA wrote: They have a PostgreSQL setup guide from Fusion recommending the following settings: effective_io_concurrency=0 bgwriter_lru_maxpages=0 random_page_cost=0.1 sequential_page_cost=0.1
 Well, since FusionIO drives have a limited write cycle (5PB?), I can some

[PERFORM] PostgreSQL settings for running on an SSD drive

2013-06-20 Thread CS DBA
All; I'm working with a client running PostgreSQL on a Fusion-IO drive. They have a PostgreSQL setup guide from Fusion recommending the following settings: effective_io_concurrency=0 bgwriter_lru_maxpages=0 random_page_cost=0.1 sequential_page_cost=0.1
 These seem odd to me, effectively turni