Re: What Linux edition we should chose?

From: Nilesh Govindarajan <lists(at)itech7(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: 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 05:39:12
Message-ID: AANLkTinufXN4gvNIUWjPpeUQrjRXCzQf_nJ7a3kgbKlW@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/6/1 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>:
> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-06-01 06:13:02 Re: server-side extension in c++
Previous Message Devrim GÜNDÜZ 2010-06-01 05:35:15 Re: What Linux edition we should chose?