X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3D6D54758E6 for ; Mon, 24 Feb 2003 05:31:52 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 57565-05 for ; Mon, 24 Feb 2003 05:31:41 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id CEEA4474E5C for ; Mon, 24 Feb 2003 05:31:35 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h1OAVba29545 for ; Mon, 24 Feb 2003 16:01:37 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h1OAVat29539 for ; Mon, 24 Feb 2003 16:01:37 +0530 From: "Shridhar Daithankar" To: "'pgsql-performance@postgresql.org'" Date: Mon, 24 Feb 2003 16:02:17 +0530 MIME-Version: 1.0 Subject: Re: partitioning os swap data log tempdb Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E5A4209.14763.368CC8@localhost> In-reply-to: <5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/171 X-Sequence-Number: 1227 On 24 Feb 2003 at 10:52, Schaefer, Mario wrote: > Hi, > > we want to migrate from MS SQL Server (windows2000) > to PostgreSQL (Linux) :-)) > and we want to use the old MSSQL Hardware. > > Dual Pentium III 800 > 1 GB RAM > 2 IDE 10 GB > 2 RAID Controller (RAID 0,1 aviable) with 2 9GB SCSI HDD > 1 RAID Controller (RAID 0,1,5 aviable) with 3 18GB SCSI HDD > > The configuration for MS-SQL was this: > OS on the 2 IDE Harddisks with Software-RAID1 > SQL-Data on RAID-Controller with RAID-5 (3 x 18GB SCSI Harddisks) > SQL-TempDB on RAID-Controller with RAID-1 (2 x 9GB SCSI Harddisk) > SQL-TransactionLog on RAID-Controller with RAID-1 (2 x 9GB SCSI Harddisk) > > Can i make a similar configuration with PostgreSQL? > Or what is the prefered fragmentation for > operatingsystem, swap-partition, data, indexes, tempdb and transactionlog? Hmm.. You can put your OS on IDE and databases on 3x18GB SCSI. Postgresql can not split data/indexes/tempdb etc. So they will be on one drive. You don't have much of a choice here. > What is pg_xlog and how important is it? It is transaction log. It is hit every now and then for insert/update/deletes. Symlinking it to a separate drive would be a great performance boost. Put it on the other SCSI disk. AFAIK, it is a single file. I suggest you put WAL and xlog on other 2x9GB SCSI drive. You need to shut down postgresql after schema creation and symlink the necessary files by hand. If postgresql ever recreates these files/directories by hand, it will drop the symlinks and recreate the files. In that case you need to redo the exercise of symlinkg. > What ist the prefered filesystem (ext2, ext3 or raiserfs)? reiserfs or XFS. > We want to use about 20 databases with varios size from 5 MB to 500MB per > database > and more selects than inserts (insert/select ratio about 1/10) for fast > webaccess. shouldn't be a problem. Tune shared_buffers around 150-250MB. Beef up FSM entries, sort mem and vacuum regularly. HTH Bye Shridhar -- Slous' Contention: If you do a job too well, you'll get stuck with it.