Re: What Linux edition we should chose?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Nilesh Govindarajan <lists(at)itech7(dot)com>
Cc: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: What Linux edition we should chose?
Date: 2010-06-01 06:26:17
Message-ID: AANLkTimyvzuxbIOeY1V16HXahMlLtySUVqrBH1l4tfp0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/5/31 Nilesh Govindarajan <lists(at)itech7(dot)com>:

> I run my site (see my signature) on a self managed VPS. I was using
> the default PGSQL RPM from the fedora repository, the site was getting
> way slow. So I compiled all the stuff apache, php and postgresql with
> custom gcc flags, which improved performance like hell.
> This may not apply to all, its my experience; not an illusion because
> I asked other site contributors also about the speed, they said it was
> much better.

I have fond memories of having a single script to do all that on
RedHat 5.1 back when I started out. (Not RHEL 5.1, RedHat 5.1)
Honestly, for our single purpose corporate intranet machine it was
perfection, and that machine ran 24/7 for years after I left with only
minor maintenance. We were on RedHat 9 or something when I left. I
still build mutliple builds of pgsql, now on RHEL 5.latest, and it's
pretty easy. I just make a configure.local file, use that for each
new version etc so it's just like the last.

But for php I use eaccelerator and it's a necessity even with powerful
servers. Drops load on heavy web servers by factors of 10 or 20.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gareth.Williams 2010-06-01 06:44:35 create index concurrently - duplicate index to reduce time without an index
Previous Message Craig Ringer 2010-06-01 06:13:02 Re: server-side extension in c++