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

partitioning os swap data log tempdb

From: "Schaefer, Mario" <Schaefer(dot)Mario(at)dd-v(dot)de>
To: "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: partitioning os swap data log tempdb
Date: 2003-02-24 09:52:55
Message-ID: 5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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
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?

What is pg_xlog and how important is it?

What ist the prefered filesystem (ext2, ext3 or raiserfs)?

We want to use about 20 databases with varios size from 5 MB to 500MB per
and more selects than inserts (insert/select ratio about 1/10) for fast

Thank you for your hints!



pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2003-02-24 10:32:17
Subject: Re: partitioning os swap data log tempdb
Previous:From: Tom LaneDate: 2003-02-24 02:28:54
Subject: Re: slow query

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