| From: | Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk> |
|---|---|
| To: | PostgreSQL Administrators Mailing List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PostgreSql under Linux |
| Date: | 2003-08-06 21:39:52 |
| Message-ID: | Pine.LNX.4.50.0308062237360.18070-100000@short.lancs.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-08-06 23:43:53 | Re: Postgresql slow on XEON 2.4ghz/1gb ram |
| Previous Message | Neil Conway | 2003-08-06 21:33:01 | Re: PostgreSql under Linux |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-06 22:13:54 | Re: Broken pipe at PQconnectdb |
| Previous Message | Ron Johnson | 2003-08-06 21:37:20 | Re: Error while running pg_dump |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-06 21:41:43 | Re: How to efficiently duplicate a whole schema? |
| Previous Message | Neil Conway | 2003-08-06 21:33:01 | Re: PostgreSql under Linux |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-06 21:50:19 | Re: PostgreSQL and Journaled File Systems |
| Previous Message | Neil Conway | 2003-08-06 21:33:01 | Re: PostgreSql under Linux |