how to configure my new server

From: "philip johnson" <philip(dot)johnson(at)atempo(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: how to configure my new server
Date: 2003-02-05 10:54:44
Message-ID: NDBBJLHHAKJFNNCGFBHLIEKPEKAA.philip.johnson@atempo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I've a new configuration for our web server

Processor Processeur Intel Xeon 2.0 Ghz / 512 Ko de cache L2
Memoiry 1 Go DDR SDRAM
Disk1 18Go Ultra 3 (Ultra 160) SCSI 15 Ktpm
Disk2 18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
Disk3 18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
Disk4 18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
Disk5 36Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm

I will install a Mandrake 8.2

It's an application server that runs things other than just postgresql.
It also runs: apache + Php , bigbrother, log analyser.

At the moment, on my old server, there's postgresql 7.2.3
my database takes 469M and there are approximatively
5 millions query per day

what values should I use for

linux values:
kernel.shmmni = 4096
kernel.shmall = 32000000
kernel.shmmax = 256000000

postgresql values:
shared_buffers
max_fsm_relations
max_fsm_pages
wal_buffers
wal_files
sort_mem
vacuum_mem

any other advices are welcome

thanks in advance

---------------------
Philip johnson
01 64 86 83 00
http://www.atempo.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Keith Bottner 2003-02-05 16:16:28 Postgres and SAN performance?
Previous Message Andreas Pflug 2003-02-04 15:11:22 EXPLAIN not helpful for DELETE