2010/6/1 Devrim GÜNDÜZ <devrim@xxxxxxxxxx>: > Hi, > > On Tue, 2010-06-01 at 06:59 +0530, Nilesh Govindarajan wrote: >> Self compilation has the advantage of custom gcc flags like -O3 -march >> -msse, etc. which can improve performance. > > I started to think that you have zero idea about building binary > packages. > >> Building RPMs is not a task that everyone can do. It requires >> extensive reading about rpmbuild and writing the specfile. > > Really? > > http://people.planetpostgresql.org/devrim/index.php?/archives/44-How-To-Build-Your-Own-PostgreSQL-and-related-software-RPMs-on-CentOSRHELFedora.html > > I can't see anything except svn co and make build there. Do you still > need an extensive reading? > >> So if you install directly from source without RPM, it won't satisfy >> the libpq.so dependency, so you cannot install applications using yum. >> This is not the case with Arch PKGBUILD, because the PKGBUILD is just >> a bash script. > > Now I'm sure that you don't have any idea about PostgreSQL RPM packages: > > http://svn.pgrpms.org/browser/rpm/redhat/8.4/compat-postgresql/EL-5 > > might give you a clue. > > You may think that ArchLinux is fine for you, but please pick up correct > arguments for RPMs first. > > Devrim - The RPM Packager > -- > Devrim GÜNDÜZ > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > PostgreSQL RPM Repository: http://yum.pgrpms.org > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz > @Devrim, I may be wrong at sometimes, because I have not done any qualification research on this. All I have learned from Google and self experience. 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. -- Nilesh Govindarajan Facebook: nilesh.gr Twitter: nileshgr Website: www.itech7.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general