Re: [PERFORM] Hardware upgraded but performance still ain't good enough

2006-08-09 Thread Merlin Moncure
On 8/7/06, Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote: "we recently upgraded our dual Xeon Dell to a brand new Sun v40z with 4 opterons, 16GB of memory and MegaRAID with enough disks. OS is Debian Sarge amd64, PostgreSQL is 8.0.3." on (http://archives.postgresql.org/pgsql-performance/2005-07/msg

Re: [PERFORM] Hardware upgraded but performance still ain't good enough

2006-08-09 Thread Stephen Frost
* David Lang ([EMAIL PROTECTED]) wrote: > there's a huge difference between 'works on debian' and 'supported on > debian'. I do use debian extensivly, (along with slackware on my personal > machines), so i am comfortable getting things to work. but 'supported' > means that when you run into a pr

Re: [PERFORM] Hardware upgraded but performance still ain't good enough

2006-08-08 Thread Stephen Frost
Alvaro, * Alex Turner ([EMAIL PROTECTED]) wrote: > The other thing is you will probably want to turn on stats in postgres to > figure out which queries are the bad ones (does anyone have good docs posted > for this?). Once you have identified the bad queries, you can explain > analyze them, and f

Re: [PERFORM] Hardware upgraded but performance still ain't good enough

2006-08-08 Thread Stephen Frost
* Alex Turner ([EMAIL PROTECTED]) wrote: > First off - very few third party tools support debian. Debian is a sure > fire way to have an unsupported system. Use RedHat or SuSe (flame me all > you want, it doesn't make it less true). Yeah, actually, it does make it less true since, well, it's rea

Re: [PERFORM] Hardware upgraded but performance still ain't good enough

2006-08-07 Thread Alex Turner
First off - very few third party tools support debian.  Debian is a sure fire way to have an unsupported system.  Use RedHat or SuSe (flame me all you want, it doesn't make it less true).Second, run bonnie++ benchmark against your disk array(s) to see what performance you are getting, and make sure