Re: PostgreSql under Linux - Mailing list pgsql-admin

From Sam Barnett-Cormack
Subject Re: PostgreSql under Linux
Date
Msg-id Pine.LNX.4.50.0308062237360.18070-100000@short.lancs.ac.uk
Whole thread Raw
In response to PostgreSql under Linux  ("Wilson A. Galafassi Jr." <juniorlist@yahoo.com.br>)
List pgsql-admin
On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote:

> Hello people.
>
> I'm installing Postgresql under linux for better performance and i want to know how is the best configuration.
>
> My server is a dual pentium3 1ghz/1gb ram/36gb scsi. running only postgresql. My question is:
> 1. What is the best linux distribuition for better performance?

LFS (http://www.linuxfromscratch.org/) if you have the time. WARNING: it
is a major undertaking, but for a machine dedicated to one task, where
virtually everything can be well-optimised for the machine, it has major
performance and admin benefits.

Only try it if you have a lot of time and/or already know linux well. If
you have a *lot* of time, you will gain the knowledge as you go. If you
decide to, I'll see you on *that* mailing list.

Also, I recommend slackware as an LFS base.

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: syslog enabled causes random hangs?
Next
From: Bruce Momjian
Date:
Subject: Re: Postgresql slow on XEON 2.4ghz/1gb ram