| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | "Wilson A(dot) Galafassi Jr(dot)" <juniorlist(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSql under Linux |
| Date: | 2003-08-06 21:33:01 |
| Message-ID: | 20030806213301.GA28017@home.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance pgsql-sql |
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Barnett-Cormack | 2003-08-06 21:39:52 | Re: PostgreSql under Linux |
| Previous Message | Wilson A. Galafassi Jr. | 2003-08-06 20:31:38 | ext3 block size |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-06 21:37:20 | Re: Error while running pg_dump |
| Previous Message | Tom Lane | 2003-08-06 20:54:32 | Re: Error while running pg_dump |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Barnett-Cormack | 2003-08-06 21:39:52 | Re: PostgreSql under Linux |
| Previous Message | Sebastien Lemieux | 2003-08-06 21:22:05 | Re: How to efficiently duplicate a whole schema? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Barnett-Cormack | 2003-08-06 21:39:52 | Re: PostgreSql under Linux |
| Previous Message | Roberto Mello | 2003-08-06 21:16:45 | PostgreSQL and Journaled File Systems |