PostgreSql under Linux

On Wed, Aug 06, 2003 at 03:03:41PM -0300, Wilson A. Galafassi Jr. wrote:

I'm installing Postgresql under linux for better performance and i want to know how is the best configuration.

1. What is the best linux distribuition for better performance?

The Linux distribution itself isn't that important, IMHO. Spend some time
selecting the right filesystem (check the archives for threads on this
topic), the right kernel (and perhaps compiling your own from scratch),
perhaps some kernel tuning (I/O scheduler, etc.), and so forth.

2. Does exists any compilation options to better performance on this machine?

Not compilation options, but there are plenty of configuration settings
you should be tweaking to ensure good performance. You can find a list
of configuration options here:

http://www.postgresql.org/docs/7.3/static/runtime-config.html

-Neil

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

I say go for GENTOO :)

You can compile all the system exactly for your mechine / cpu.
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

----- Original Message -----
From: Wilson A. Galafassi Jr.
To: "Undisclosed-Recipient:;"@svr1.postgresql.org
Sent: Wednesday, August 06, 2003 8:03 PM
Subject: [GENERAL] PostgreSql under Linux

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?
2. Does exists any compilation options to better performance on this machine?

Thanks

Wilson Galafassi