Re: [PERFORM] Configuring PostgreSQL to minimize impact of checkpoints

2004-05-11 Thread Rob Fielding
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 --

Re: [PERFORM] OT: Help with performance problems

2004-04-26 Thread Rob Fielding
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

Re: [PERFORM] Where to start for performance problem?

2003-11-25 Thread Rob Fielding
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

Re: [PERFORM] tuning questions

2003-12-04 Thread Rob Fielding
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

[PERFORM] WAL Optimisation - configuration and usage

2004-02-28 Thread Rob Fielding
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

Re: [PERFORM] WAL Optimisation - configuration and usage

2004-02-29 Thread Rob Fielding
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

Re: [PERFORM] WAL Optimisation - configuration and usage

2004-03-01 Thread Rob Fielding
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)--