From juniorlist@yahoo.com.br Wed Aug  6 18:03:32 2003
X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 98BD6D1C9E0
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 18:03:32 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 60788-05
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 15:02:10 -0300 (ADT)
Received: from smtp013.mail.yahoo.com (smtp013.mail.yahoo.com
 [216.136.173.57])
	by svr1.postgresql.org (Postfix) with SMTP id DE72CD1C4C1
	for <pgsql-admin@postgresql.org>; Wed,  6 Aug 2003 15:03:20 -0300 (ADT)
Received: from unknown (HELO notebook) (juniorlist@200.180.192.112 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Aug 2003 18:03:20 -0000
Message-ID: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
From: "Wilson A. Galafassi Jr." <juniorlist@yahoo.com.br>
To: <"Undisclosed-Recipient:;"@svr1.postgresql.org>
Subject: PostgreSql under Linux
Date: Wed, 6 Aug 2003 15:03:41 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01DA_01C35C2B.EC176090"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50
X-Spam-Level: 
X-Archive-Number: 200308/83
X-Sequence-Number: 9806

This is a multi-part message in MIME format.

------=_NextPart_000_01DA_01C35C2B.EC176090
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 postgresq=
l. My question is:
1. What is the best linux distribuition for better performance?
2. Does exists any compilation options to better performance on this machin=
e?

Thanks

Wilson Galafassi
------=_NextPart_000_01DA_01C35C2B.EC176090
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello people.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm installing Postgresql under linux for =
better=20
performance and i want to know how is the best configuration.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>My server is a dual pentium3 1ghz/1gb ram/=
36gb=20
scsi. running only postgresql. My question is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1. What is the best linux distribuition fo=
r better=20
performance?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2. Does exists any compilation options to =
better=20
performance on this machine?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Wilson Galafassi</FONT></DIV></BODY></HTML>

------=_NextPart_000_01DA_01C35C2B.EC176090--




From neilc@samurai.com Wed Aug  6 21:33:10 2003
X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id B772ED1C92D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 21:33:10 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 85552-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 18:31:50 -0300 (ADT)
Received: from home.samurai.com (home.samurai.com [205.207.28.66])
	by svr1.postgresql.org (Postfix) with ESMTP id C5018D1C91E
	for <pgsql-performance@postgresql.org>;
	Wed,  6 Aug 2003 18:32:59 -0300 (ADT)
Received: by home.samurai.com (Postfix, from userid 1014)
	id B66F026219; Wed,  6 Aug 2003 17:33:01 -0400 (EDT)
Date: Wed, 6 Aug 2003 17:33:01 -0400
From: Neil Conway <neilc@samurai.com>
To: "Wilson A. Galafassi Jr." <juniorlist@yahoo.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSql under Linux
Message-ID: <20030806213301.GA28017@home.samurai.com>
References: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/121
X-Sequence-Number: 2938

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




From s.barnett-cormack@lancaster.ac.uk Wed Aug  6 21:36:38 2003
X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 62991D1C9C8
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 21:36:38 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 83339-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 18:35:17 -0300 (ADT)
Received: from zooty.lancs.ac.uk (zooty.lancs.ac.uk [148.88.16.231])
	by svr1.postgresql.org (Postfix) with ESMTP id 4C882D1C91D
	for <pgsql-admin@postgresql.org>; Wed,  6 Aug 2003 18:36:27 -0300 (ADT)
Received: from mail.lancs.ac.uk ([148.88.1.10] helo=marl.lancs.ac.uk)
	by zooty.lancs.ac.uk with esmtp (Exim 4.20) id 19kVxM-0004Vk-RY
	for pgsql-admin@postgresql.org; Wed, 06 Aug 2003 22:36:28 +0100
Received: from faa034000015.lancs.ac.uk ([148.88.81.14]
 helo=short.lancs.ac.uk)
	by marl.lancs.ac.uk with esmtp (Exim 3.36 #1) id 19kVxM-0004GT-00
	for pgsql-admin@postgresql.org; Wed, 06 Aug 2003 22:36:28 +0100
Date: Wed, 6 Aug 2003 22:39:52 +0100 (BST)
From: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
X-X-Sender: sdb@short.lancs.ac.uk
To: PostgreSQL Administrators Mailing List <pgsql-admin@postgresql.org>
Subject: Re: PostgreSql under Linux
In-Reply-To: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
Message-ID: <Pine.LNX.4.50.0308062237360.18070-100000@short.lancs.ac.uk>
References: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/90
X-Sequence-Number: 9813

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 miki@canaan.co.il Thu Aug  7 07:51:18 2003
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 09C1BD1C91E
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 07:51:18 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 49236-01
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 04:49:55 -0300 (ADT)
Received: from mxout3.netvision.net.il (mxout3.netvision.net.il [194.90.9.24])
	by svr1.postgresql.org (Postfix) with ESMTP id 0365CD1C914
	for <pgsql-general@postgresql.org>;
	Thu,  7 Aug 2003 04:51:07 -0300 (ADT)
Received: from mikislap ([217.132.27.49]) by mxout3.netvision.net.il
	(iPlanet Messaging Server 5.2 HotFix 1.14 (built Mar 18 2003))
	with SMTP id <0HJ80092TOH62P@mxout3.netvision.net.il> for
	pgsql-general@postgresql.org; Thu, 07 Aug 2003 10:51:07 +0300 (IDT)
Date: Thu, 07 Aug 2003 10:51:03 +0200
From: Ben-Nes Michael <miki@canaan.co.il>
Subject: Re: PostgreSql under Linux
To: "Wilson A. Galafassi Jr." <juniorlist@yahoo.com.br>,
	postgresql <pgsql-general@postgresql.org>
Message-id: <003201c35cc1$09798bf0$0400000a@mikislap>
MIME-version: 1.0
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
Content-type: multipart/alternative;
	boundary="Boundary_(ID_N3aY3V49E4O82SHd/NmIYA)"
X-Priority: 3
X-MSMail-priority: Normal
References: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/332
X-Sequence-Number: 46749

This is a multi-part message in MIME format.

--Boundary_(ID_N3aY3V49E4O82SHd/NmIYA)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT

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

--Boundary_(ID_N3aY3V49E4O82SHd/NmIYA)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I say go for GENTOO :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>You can compile all the system exactly for your 
mechine / cpu.</FONT></DIV>
<DIV>--------------------------<BR>Canaan Surfing Ltd.<BR>Internet Service 
Providers<BR>Ben-Nes Michael - Manager<BR>Tel: 972-4-6991122<BR>Fax: 
972-4-6990098<BR><A 
href="http://www.canaan.net.il">http://www.canaan.net.il</A><BR>--------------------------<BR></DIV>
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
  <A title=juniorlist@yahoo.com.br href="mailto:juniorlist@yahoo.com.br">Wilson 
  A. Galafassi Jr.</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A 
  title='"Undisclosed-Recipient:;"@svr1.postgresql.org' 
  href='mailto:"Undisclosed-Recipient:;"@svr1.postgresql.org'>"Undisclosed-Recipient:;"@svr1.postgresql.org</A> 
  </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, August 06, 2003 8:03 
  PM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> [GENERAL] PostgreSql under 
  Linux</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=Arial size=2>Hello people.</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>I'm installing Postgresql under linux for better 
  performance and i want to know how is the best configuration.</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>My server is a dual pentium3 1ghz/1gb ram/36gb 
  scsi. running only postgresql. My question is:</FONT></DIV>
  <DIV><FONT face=Arial size=2>1. What is the best linux distribuition for 
  better performance?</FONT></DIV>
  <DIV><FONT face=Arial size=2>2. Does exists any compilation options to better 
  performance on this machine?</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Wilson 
Galafassi</FONT></DIV></BLOCKQUOTE></BODY></HTML>

--Boundary_(ID_N3aY3V49E4O82SHd/NmIYA)--