partitioning os swap data log tempdb
От | Schaefer, Mario |
---|---|
Тема | partitioning os swap data log tempdb |
Дата | |
Msg-id | 5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH обсуждение исходный текст |
Ответы |
Re: partitioning os swap data log tempdb
Re: partitioning os swap data log tempdb Re: partitioning os swap data log tempdb Re: partitioning os swap data log tempdb |
Список | 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
В списке pgsql-performance по дате отправления: