X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 486F147595A for ; Thu, 6 Feb 2003 12:05:12 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 926204758E6 for ; Thu, 6 Feb 2003 12:04:40 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2827544; Thu, 06 Feb 2003 09:04:39 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "philip johnson" , Subject: Re: how to configure my new server Date: Thu, 6 Feb 2003 09:04:11 -0800 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Message-Id: <200302060904.11652.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/18 X-Sequence-Number: 1074 Phillip, First, a disclaimer: my advice is without warranty whatsoever. You want a= =20 warranty, you gotta pay me. > 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 No RAID, though? Think carefully about which disks you put things on. Ideally, the OS, the= =20 web files, the database files, the database log, and the swap partition wil= l=20 all be on seperate disks. With a large database you may even think about= =20 shifting individual tables or indexes to seperate disks. > linux values: > kernel.shmmni =3D 4096 > kernel.shmall =3D 32000000 > kernel.shmmax =3D 256000000 These are probably too high, but I'm ready to speak authoritatively on that. > postgresql values: > shared_buffers > max_fsm_relations > max_fsm_pages > wal_buffers > wal_files > sort_mem > vacuum_mem Please visit the archives for this list. Setting those values is a topic = of=20 discussion for 50% of the threads, and there is yet no firm agreement on go= od=20 vs. bad values. Also, you need to ask youself more questions before you start setting value= s: 1. How many queries does my database handle per second or minute? 2. How big/complex are those queries? 3. What is the ratio of database read activity vs. database writing activit= y? 4. What large tables in my database get queried simultaneously/together? 5. Are my database writes bundled into transactions, or seperate? etc. Simply knowing the size of the database files isn't enough. --=20 Josh Berkus Aglio Database Solutions San Francisco