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
Date: Wed, 6 Aug 2003 17:33:01 -0400
Message-ID: <20030806213301.GA28017@home.samurai.com> (raw)
In-Reply-To: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
References: <01dd01c35c45$141a42b0$70c0b4c8@notebook>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: neilc@samurai.com, juniorlist@yahoo.com.br, pgsql-performance@postgresql.org
Subject: Re: PostgreSql under Linux
In-Reply-To: <20030806213301.GA28017@home.samurai.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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