System tuning - Mailing list pgsql-general

From Gyorgy Molnar
Subject System tuning
Date
Msg-id 007801c3f988$f1896e10$8f01a8c0@i8600
Whole thread Raw
In response to DBD::Pg 1.32 ready for testing  (greg@turnstep.com)
Responses Re: System tuning  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Greetings,

I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who
could help me to fine tune the Kernel for PgSql, and also the with the
proper settings for the PgSql server. I have two additional java program
running on that computer, otherwise I used a custom installation with the
minimal neccessary packages (No X-Server is initalled).

I read the docuentation, and also the PostgreSQL Hardware Performance Tuning
by Bruce Momjian.

Both of them was very usefull, I could manage to come up with the
configuration. Everything works fine, but I'm not sure I have chosen the
best settings.

Thank you in advance.

Kind regards,
Yuri

ps. I almost forgot; I need 64 connections at the same times, and the max
record length is aroung 1024 bytes.


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: problem with cursur within a scriptfile
Next
From: Tom Lane
Date:
Subject: Re: problem with cursur within a scriptfile