Re: optimum postgres server configuration

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: tom dyson <tom(at)torchbox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Neal Todd <neal(at)torchbox(dot)com>
Subject: Re: optimum postgres server configuration
Date: 2003-08-05 22:28:35
Message-ID: 3F302F93.3030704@commandprompt.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-05 22:46:47 Re: indices and cidr/inet type
Previous Message Tom Lane 2003-08-05 22:24:35 Re: INSERT RULE QUERY ORDER