Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE
Mark, Along similar lines - have generally obtained better server performance (and stability) from most Linux distros after replacing their supplied kernel with one from kernel.org . Hmmm any anecdotes about replacing Red Hat 2.4.18 to .24? I've been having problems I can't track down on that platform ... -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE
We use a server at work that is patched RH 7.3 / 2.4.18 with 2.4.21 (or thereabouts its .24). We have stability issues with Java 1.4 / Tomcat 4.1 but not Pg. It might even be worth building yourself a vanilla 2.4.18 kernel and seeing if that makes any difference... regards Mark Josh Berkus wrote: Mark, Along similar lines - have generally obtained better server performance (and stability) from most Linux distros after replacing their supplied kernel with one from kernel.org . Hmmm any anecdotes about replacing Red Hat 2.4.18 to .24? I've been having problems I can't track down on that platform ... ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE
Along similar lines - have generally obtained better server performance (and stability) from most Linux distros after replacing their supplied kernel with one from kernel.org . regards Mark Josh Berkus wrote: Folks, While debugging a wireless card, I came across this interesting bit: http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html What it indicates is that by default SuSE 9.0 plays with the timeslice values for the Linux kernel in order to provide a smoother user experience. In my experience, this can be very bad news for databases under heavy multi-user load. I would suggest that anyone installing a SuSE 9.0 PostgreSQL server remove the Desktop pararmeter in the bootloader configuration. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster