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