[PERFORM] Postgresql Hardware - Recommendations

[Christian.Kastner]

Hello,

My company has decided to migrate our Oracle database to postgresql8. We
will aquire a new server for this, and would very much appreciate your
advice.

NOTE: The applications accessing the database are developed and
maintained externally, and unfortunately, the developers have not yet
given us detailed information on their requirements. The only info I can
give so far is that the database size is about 60GB, and that it will be
frequently accessed by multiple users (about 100 will be connected
during business hours). The applications accessing the database are
mostly reporting tools.

I know that the performance question will ultimately boil down to "it
depends what you want to do with it", but at the moment I'm very much
interested if there are any general issues we should look out for.

The questions we are asking us now are:

1) Intel or AMD (or alternate Platform)
Are we better of with Xeons or Opterons? Should we consider the IBM
OpenPower platform?

2) CPUs vs cache
Would you rather have more CPUs or more cache? Eg: 4x Xeon 1MB vs 2x
Xeon 8MB

3) CPUs vs Memory
Would you rather have 4x CPUs and 8GB of memory, or 2x CPUs with 16GB of
memory?

Thanks in advance for all your replies!

Best Regards,
Christian Kastner

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [PERFORM] Postgresql Hardware - Recommendations

[Christian.Kastner]

Andrew, Matthew, thanks to you both four your advice. I'm sorry I couldn't 
provide more details to the situation, I will post again as soon I get them. 

Time to share your insights with the colleagues :)

Best Regards,
Chris

-Ursprüngliche Nachricht-
Von: Paul Ramsey [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 06. September 2005 06:13
An: Kastner Christian; Kastner Christian
Betreff: Re: [PERFORM] Postgresql Hardware - Recommendations

For a database, I would almost always prioritize:
- I/O
- RAM
- CPU

So, fast drives (SCSI 1RPM or better in a RAID configuration,  
more spindles == more throughput), then memory (more memory == more  
of the database off disk in cache == faster response), then more CPU  
(more concurrent request handling).

Paul

On 5-Sep-05, at 6:50 AM, <[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]> wrote:

> Hello,
>
> My company has decided to migrate our Oracle database to  
> postgresql8. We
> will aquire a new server for this, and would very much appreciate your
> advice.
>
> NOTE: The applications accessing the database are developed and
> maintained externally, and unfortunately, the developers have not yet
> given us detailed information on their requirements. The only info  
> I can
> give so far is that the database size is about 60GB, and that it  
> will be
> frequently accessed by multiple users (about 100 will be connected
> during business hours). The applications accessing the database are
> mostly reporting tools.
>
> I know that the performance question will ultimately boil down to "it
> depends what you want to do with it", but at the moment I'm very much
> interested if there are any general issues we should look out for.
>
> The questions we are asking us now are:
>
> 1) Intel or AMD (or alternate Platform)
> Are we better of with Xeons or Opterons? Should we consider the IBM
> OpenPower platform?
>
> 2) CPUs vs cache
> Would you rather have more CPUs or more cache? Eg: 4x Xeon 1MB vs 2x
> Xeon 8MB
>
> 3) CPUs vs Memory
> Would you rather have 4x CPUs and 8GB of memory, or 2x CPUs with  
> 16GB of
> memory?
>
> Thanks in advance for all your replies!
>
> Best Regards,
> Christian Kastner
>
> ---(end of  
> broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings