Unix Technical Forum

Hardware upgraded but performance still ain't good enough

This is a discussion on Hardware upgraded but performance still ain't good enough within the Pgsql Performance forums, part of the PostgreSQL category; --> On Wed, 9 Aug 2006, Joshua D. Drake wrote: >>> even many of the companies that offer support for ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-19-2008, 09:14 AM
David Lang
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good

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 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.

David Lang

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 04-19-2008, 09:14 AM
Joshua D. Drake
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good


>> 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 *what* companies. Any reputable
PostgreSQL company is going to support Linux as a whole except maybe
some fringe distros like Gentoo or RedFlag. Not to mention FreeBSD and
Solaris.

Sincerely,

Joshua D. Drake


>
> David Lang
>



--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 04-19-2008, 09:14 AM
David Lang
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good

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 catagory.

>
> I know, but I am curious as to *what* companies. Any reputable PostgreSQL
> company is going to support Linux as a whole except maybe some fringe distros
> like Gentoo or RedFlag. Not to mention FreeBSD and Solaris.


I'm not going to name names in public, but I will point out that different
companies definitions of what constatutes 'fringe distros' are different.
For some any linux other then RedHat Enterprise or SuSE is a fringe distro
(with SuSE being a relativly recent addition, for a while RedHat were
frequently the only supported distro versions)

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

David Lang

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #14 (permalink)  
Old 04-19-2008, 09:14 AM
Scott Marlowe
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good

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 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 *what* companies. Any reputable PostgreSQL
> > company is going to support Linux as a whole except maybe some fringe distros
> > like Gentoo or RedFlag. Not to mention FreeBSD and Solaris.

>
> I'm not going to name names in public, but I will point out that different
> companies definitions of what constatutes 'fringe distros' are different.
> For some any linux other then RedHat Enterprise or SuSE is a fringe distro
> (with SuSE being a relativly recent addition, for a while RedHat were
> frequently the only supported distro versions)
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #15 (permalink)  
Old 04-19-2008, 09:14 AM
Steve Atkins
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good


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 Linux. It doesn't matter what trademark you put on top of
> it. As long as they are running a current version of Linux (e.g;
> kernel 2.6) they should be fine.


That's really not the case, at least to the degree that makes a
difference between "supported" and "unsupported".
>
> With Debian that may or may not be the case and that could be an
> issue.
> To get the best luck, I would suggest (if you want to stay with a
> Debian base) Ubuntu Dapper LTS.


Different Linux distributions include different shared libraries, put
different things in different places and generally break applications
in a variety of different ways (SELinux would be one example of
that commonly seen here).

If I don't QA my application on it, it isn't supported. I can't
necessarily
replicate problems on Linux distributions I don't have installed in
my QA lab, so I can't guarantee to fix problems that are specific
to that distribution. I can't even be sure that it will install and run
correctly without doing basic QA of the installation process on
that distribution.

And in my case that's just for user space applications. It's got to
be even worse for hardware drivers.

Our usual phrase is "We support RedHat versions *mumble*
only. We expect our application to run correctly on any Linux
distribution, though you may have to install additional shared
libraries."

I'm quite happy with customers running Debian, SuSe or what
have you, as long as they have access to a sysadmin who's
comfortable with that distribution. (I'd probably deny support to
anyone running Gentoo, though )

We've never had big problems with people running our apps on
"unsupported" problems, but those users have had to do some
more diagnosis of problems themselves, and we've been less
able to support them than we can users who use the same
distribution we QA on.

(It's not just Linux, either. We "support" Windows XP, but we run
just fine on 2000 and 95/98.)

Cheers,
Steve


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #16 (permalink)  
Old 04-19-2008, 09:15 AM
Joshua D. Drake
 
Posts: n/a
Default Re: Hardware upgraded but performance still ain't good

>>
>> 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 *chuckles* and whispers to himself.. no wonder were winning.

Sincerely,

Joshua D. Drake


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com