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
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
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
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,
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
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
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