Ben-Nes Michael writes:
> 1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed,
> efficiency )
PostgreSQL might work better on "simple" file systems, so you avoid making
the head run all over the place for writing its own log and the PostgreSQL
log. Some have even suggested FAT for the data files. Good bets for
improving performance are putting the WAL logs and the indexes not on the
same spindle as the table files. Of course, certain RAID configurations
achieve a similar effect.
> 2. What is the most importent part in the Hardware ? fast HD, alot of mem,
> or maybe strong cpu ?
Lots of memory, so you can cache a large fraction of the data in memory.
A good hard disk, if you do a lot of updates and/or your memory is not big
enough to cache most of the data. CPU is not as important.
--
Peter Eisentraut [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
