2010/5/31 Nilesh Govindarajan <lists@xxxxxxxxxx>: > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
