Skip site navigation (1) Skip section navigation (2)

Configuration for my server

From: Marcin Giedz <marcin(dot)giedz(at)eulerhermes(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Configuration for my server
Date: 2005-02-24 13:54:46
Message-ID: 200502241454.46733.marcin.giedz@eulerhermes.pl (view raw or flat)
Thread:
Lists: pgsql-admin
Hello...

Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM 
basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs  
146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to 
find best configuration. Nowadys we have about 300 clients connected to mysql 
server (we plan to switch to postgresql) but in the future there will be even 
1 thousand clients. Can anyone please help me what should I change in 
postgresql.conf to achieve very good performance ;) 

Thx
Marcin

Responses

pgsql-admin by date

Next:From: Rick ApichairukDate: 2005-02-24 14:39:10
Subject: Re: Configuration for my server
Previous:From: Alex GutmanDate: 2005-02-24 13:33:08
Subject: Preventing changes to default settings of a collective account?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group