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

2006-08-18 Thread Merlin Moncure
On 8/18/06, Magnus Hagander <[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). > > *cough* BS *cough* > > Linux is Linu

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

2006-08-18 Thread Magnus Hagander
> > 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). > > *cough* BS *cough* > > Linux is Linux. It doesn't matter what trademark you put on top of >

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

2006-08-09 Thread Joshua D. Drake
and please note, when I'm talking about support, it's not just postgresql support, but also hardware/driver support that can run into these problems I've run into this as well. Generally speaking, the larger the company, the more likely you are to get the "we don't support that" line. /me

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

2006-08-09 Thread Steve Atkins
On Aug 9, 2006, at 5:47 AM, Joshua D. Drake wrote: Alex Turner 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). *cough* BS *cough* Linux is L

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

2006-08-09 Thread Scott Marlowe
On Wed, 2006-08-09 at 11:37, David Lang wrote: > On Wed, 9 Aug 2006, Joshua D. Drake wrote: > > >>> Ahh and which companies would these be? As a representative of the most > >>> prominent one in the US I can tell you that you are not speaking from a > >>> knowledgeable position. > >> > >> note

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

2006-08-09 Thread David Lang
On Wed, 9 Aug 2006, Joshua D. Drake wrote: Ahh and which companies would these be? As a representative of the most prominent one in the US I can tell you that you are not speaking from a knowledgeable position. note I said many, not all. I am aware that your company does not fall into this

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

2006-08-09 Thread Joshua D. Drake
Ahh and which companies would these be? As a representative of the most prominent one in the US I can tell you that you are not speaking from a knowledgeable position. note I said many, not all. I am aware that your company does not fall into this catagory. I know, but I am curious as to

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

2006-08-09 Thread David Lang
On Wed, 9 Aug 2006, Joshua D. Drake wrote: even many of the companies that offer support for postgres have this problem. the explination is always that they can't test every distro out there so they pick a few and support those (this is one of the reasons why Ahh and which companies would th

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

2006-08-09 Thread David Lang
On Wed, 9 Aug 2006, Stephen Frost wrote: * 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'

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

2006-08-09 Thread Joshua D. Drake
Have you ever actually had that happen? I havn't and I've called support for a number of different issues for various commercial software. In the end it might boil down to some distribution-specific issue that they're not willing to fix but honestly that's pretty rare. Very rare, if you are

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

2006-08-09 Thread Joshua D. Drake
Alex Turner 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). *cough* BS *cough* Linux is Linux. It doesn't matter what trademark you put on top of i

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

2006-08-08 Thread David Lang
On Tue, 8 Aug 2006, Stephen Frost wrote: * 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

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