pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
RPM vs. Compile benefits?
3+ messages / 3 participants
[nested] [flat]

* RPM vs. Compile benefits?
@ 2004-10-22 15:04  Doug Y <dylists@ptd.net>
  0 siblings, 2 replies; 3+ messages in thread

From: Doug Y @ 2004-10-22 15:04 UTC (permalink / raw)
  To: pgsql-admin

Hello,
  I'm curious if I would see any specific benefit from compiling 
Postgres from scratch vs. using an RPM supplied by the distribution? 
We're currently using 7.4.2 from an RPM on SuSE 9.0 Pro. I'd guess RPMs 
are usually configured with the least common denominator in mind. All 
the software is stock on the system from SuSE. I'd guess I might see 
some overall system performance by a custom kernel compile (currently 
2.6.4-52-smp), but thats not directly Postgres related. Hardware is dual 
Intel P3-1Ghz / 4G Ram / raid 0 if that makes any difference.

Also, any significant reason to upgrade to 7.4.5? Obviously if compiling 
would be a boost, I'd also upgrade at the same time, but only unless I 
had a meaningful reason to compile in the first place. I've heard 7.4.2 
has some problems with index bloat? How would that manifest itself?

Thanks!



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: RPM vs. Compile benefits?
@ 2004-10-22 18:36  Devrim GUNDUZ <devrim@gunduz.org>
  parent: Doug Y <dylists@ptd.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Devrim GUNDUZ @ 2004-10-22 18:36 UTC (permalink / raw)
  To: Doug Y <dylists@ptd.net>; +Cc: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 22 Oct 2004, Doug Y wrote:

> I'm curious if I would see any specific benefit from compiling Postgres from 
> scratch vs. using an RPM supplied by the distribution?

Remembering that we can build our own RPMS using SRPMS, I've always 
believed that package management systems have much more advantages. I've 
always built my own RPMS by modifying spec files.

Regards,

- --
Devrim GUNDUZ 
devrim~gunduz.org				devrim.gunduz~linux.org.tr
 			http://www.tdmsoft.com
 			http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBeVMYtl86P3SPfQ4RAodCAKCLQOEQDiL+UKLq+tlcIYPF5uR1oACgvD/i
xgYcjSGy2L0Agv3cMvF6O8c=
=FvXb
-----END PGP SIGNATURE-----



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: RPM vs. Compile benefits?
@ 2004-10-22 18:41  Bruno Wolff III <bruno@wolff.to>
  parent: Doug Y <dylists@ptd.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruno Wolff III @ 2004-10-22 18:41 UTC (permalink / raw)
  To: Doug Y <dylists@ptd.net>; +Cc: pgsql-admin

On Fri, Oct 22, 2004 at 11:04:04 -0400,
  Doug Y <dylists@ptd.net> wrote:
> Hello,
>  I'm curious if I would see any specific benefit from compiling 
> Postgres from scratch vs. using an RPM supplied by the distribution? 
> We're currently using 7.4.2 from an RPM on SuSE 9.0 Pro. I'd guess RPMs 
> are usually configured with the least common denominator in mind. All 
> the software is stock on the system from SuSE. I'd guess I might see 
> some overall system performance by a custom kernel compile (currently 
> 2.6.4-52-smp), but thats not directly Postgres related. Hardware is dual 
> Intel P3-1Ghz / 4G Ram / raid 0 if that makes any difference.

The rpms prossibly include some stuff that is not part of the core project
but are still things you want to have. Figuring out what you want and
pulling it all together may be more work than you want to do. Also
rembember that if you change build options you should do a dump and
restore even when upgrading between minor releases in the same series
(unless you know for sure the changed build options won't change the
disk layout).

> Also, any significant reason to upgrade to 7.4.5? Obviously if compiling 
> would be a boost, I'd also upgrade at the same time, but only unless I 
> had a meaningful reason to compile in the first place. I've heard 7.4.2 
> has some problems with index bloat? How would that manifest itself?

I think the answer to this is yes you should upgrade. But you can look
at the release notes and decide for yourself.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-10-22 18:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-22 15:04 RPM vs. Compile benefits? Doug Y <dylists@ptd.net>
2004-10-22 18:36 ` Devrim GUNDUZ <devrim@gunduz.org>
2004-10-22 18:41 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox