had so much free
I/O we recently installed another app on there (based on mysql, sorry)
which runs concurrently, and itself 4 times faster than it originally did...
YMMV, just my 2p.
--
Rob Fielding
[EMAIL PROTECTED]
www.dsvr.co.uk Development Designer Servers Ltd
--
2
channel gets 40MB/sec max (pg_xlog :)
And HOW LONG does it take to detect drives during POSTo never
mind ... I really just wanna rant :) There should be a free counseling
service for enraged sysops.
--
Rob Fielding
[EMAIL PROTECTED]
www.dsvr.co.uk Development
e
it was running so badly - i just wouldn't think it would do that.
--
Rob Fielding
[EMAIL PROTECTED]
www.dsvr.co.uk Development Designer Servers Ltd
---(end of broadcast)---
TIP 9: the planner will ignore your des
50 ) / 8.2 = shared_buffers
decrease random_page_cost to 0.3 and wack up sort mem by 16 times,
effective cache size to about 50% RAM (depending on your other settings)
and try that for starters.
--
Rob Fielding
[EMAIL PROTECTED]
www.dsvr.co.uk Development Designer S
1 29696 10228 16036 801368 0 0 4038 561 1566 3288 16
12 72
Sorry it's so long but I thought some brief info would be better than
not. Thanks for reading,
--
Rob Fielding
Development
Designer Servers Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
refer to keep as much RAM available for runtime at this time.
I'm still hoping that perhaps the uber-pgadmin Mr Lane might reply about
my WAL issue :) however I'm getting the feeling now the server is
running with a much higher level of performance than it has been. Won't
know
action log file 0071001F
Looks kinda automated, but the times aren't quite even at around 6-10
minutes apart.
cheers,
--
Rob Fielding
[EMAIL PROTECTED]
www.dsvr.co.uk Development Designer Servers Ltd
---(end of broadcast)--