* Disk speed
4 drives... 7200 RPM... as big as you can get. Get 8 Meg cache drives so you have a 3 year warranty.
* Hardware RAID
3Ware IDE controller (or SATA) running RAID 10
* Memory
2 gig
* Processor speed
1800+
* Processor type
Athlon MP
* Multiple processors
2
We are able to run a 60 person insurance company entirely off of the box I described above with ZERO load problems.
And does the list have any observations regarding Postgres performance on different platforms? Our webservers run Linux (RedHat 8), but we're willing to experiment with alternatives.
Many thanks
Tom
-----------------+ tom dyson t: +44 (0)1608 811870 m: +44 (0)7958 752657 http://torchbox.com
---------------------------(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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
