Re: optimum postgres server configuration

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