pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSql under Linux
4+ messages / 4 participants
[nested] [flat]
* PostgreSql under Linux
@ 2003-08-06 18:03 Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
2003-08-06 21:33 ` Re: PostgreSql under Linux Neil Conway <neilc@samurai.com>
2003-08-06 21:39 ` Re: PostgreSql under Linux Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2003-08-07 08:51 ` Re: PostgreSql under Linux Ben-Nes Michael <miki@canaan.co.il>
0 siblings, 3 replies; 4+ messages in thread
From: Wilson A. Galafassi Jr. @ 2003-08-06 18:03 UTC (permalink / raw)
To: "Undisclosed-Recipient:;"@svr1.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSql under Linux
2003-08-06 18:03 PostgreSql under Linux Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
@ 2003-08-06 21:33 ` Neil Conway <neilc@samurai.com>
2 siblings, 0 replies; 4+ messages in thread
From: Neil Conway @ 2003-08-06 21:33 UTC (permalink / raw)
To: Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>; +Cc: pgsql-performance@postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSql under Linux
2003-08-06 18:03 PostgreSql under Linux Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
@ 2003-08-06 21:39 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2 siblings, 0 replies; 4+ messages in thread
From: Sam Barnett-Cormack @ 2003-08-06 21:39 UTC (permalink / raw)
To: PostgreSQL Administrators Mailing List <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSql under Linux
2003-08-06 18:03 PostgreSql under Linux Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
@ 2003-08-07 08:51 ` Ben-Nes Michael <miki@canaan.co.il>
2 siblings, 0 replies; 4+ messages in thread
From: Ben-Nes Michael @ 2003-08-07 08:51 UTC (permalink / raw)
To: Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>; postgresql <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-08-07 08:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-06 18:03 PostgreSql under Linux Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
2003-08-06 21:33 ` Neil Conway <neilc@samurai.com>
2003-08-06 21:39 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2003-08-07 08:51 ` Ben-Nes Michael <miki@canaan.co.il>
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