Re: [PERFORM] High concurrency OLTP database performance tuning

2006-08-31 Thread Michael Loftis
--On August 31, 2006 5:45:18 PM +0200 Cosimo Streppone [EMAIL PROTECTED] wrote: Good morning, - postgresql.conf, especially: effective_cache_size (now 5000) bgwriter_delay (500) commit_delay/commit_siblings (default) commit delay and siblings should be turned up, also

Re: [PERFORM] suggested RAID controller for FreeBSD 6.1 +PostgreSQL

2006-07-06 Thread Michael Loftis
--On July 6, 2006 2:21:15 PM -0400 Paul Khavkine [EMAIL PROTECTED] wrote: Take a look at: http://www.icp-vortex.com/english/index_e.htm They have always made good RAID controllers. I'll give a huge thumbs up for the ICPs, and also make sure you get the BBU cache as well (batter