| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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?
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
database
and more selects than inserts (insert/select ratio about 1/10) for fast
webaccess.
Thank you for your hints!
Bye,
Mario
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-02-24 10:32:17 | Re: partitioning os swap data log tempdb |
| Previous Message | Tom Lane | 2003-02-24 02:28:54 | Re: slow query |