Re: What Linux edition we should chose? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: What Linux edition we should chose?
Date
Msg-id AANLkTimyvzuxbIOeY1V16HXahMlLtySUVqrBH1l4tfp0@mail.gmail.com
Whole thread Raw
In response to Re: What Linux edition we should chose?  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-general
2010/5/31 Nilesh Govindarajan <lists@itech7.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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: server-side extension in c++
Next
From:
Date:
Subject: create index concurrently - duplicate index to reduce time without an index