pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bjoern Metzdorf <bm@turtle-entertainment.de>
To: Anjan Dave <adave@vantage.com>
Cc: pgsql-performance@postgresql.org, "Pgsql-Admin (E-mail)" <pgsql-admin@postgresql.org>
Subject: Re: [PERFORM] Quad processor options
Date: Tue, 11 May 2004 22:28:12 +0200
Message-ID: <40A1375C.1080806@turtle-entertainment.de> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098228@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098228@vt-pe2550-001.vantage.vantage.com>

Anjan Dave wrote:

> We use XEON Quads (PowerEdge 6650s) and they work nice,
 > provided you configure the postgres properly.
 > Dell is the cheapest quad you can buy i think.
 > You shouldn't be paying 30K unless you are getting high CPU-cache
 > on each processor and tons of memory.

good to hear, I tried to online configure a quad xeon here at dell 
germany, but the 6550 is not available for online configuration. at dell 
usa it works. I will give them a call tomorrow.

> I am actually curious, have you researched/attempted any 
 > postgresql clustering solutions?
 > I agree, you can't just keep buying bigger machines.

There are many asynchronous, trigger based solutions out there (eRserver 
etc..), but what we need is basically a master <-> master setup, which 
seems not to be available soon for postgresql.

Our current dual Xeon runs at 60-70% average cpu load, which is really 
much. I cannot afford any trigger overhead here. This machine is 
responsible for over 30M page impressions per month, 50 page impressums 
per second at peak times. The autovacuum daemon is a god sent gift :)

I'm curious how the recently announced mysql cluster will perform, 
although it is not an option for us. postgresql has far superior 
functionality.

> They have 5 internal drives (4 in RAID 10, 1 spare) on U320, 
 > 128MB cache on the PERC controller, 8GB RAM.

Could you tell me what you paid approximately for this setup?

How does it perform? It certainly won't be twice as fast a as dual xeon, 
but I remember benchmarking a quad P3 xeon some time ago, and it was 
disappointingly slow...

Regards,
Bjoern



view thread (25+ messages)  latest in thread

Message-ID: <40A1375C.1080806@turtle-entertainment.de>
Permalink:  ../40A1375C.1080806@turtle-entertainment.de/
Also on:    postgresql.org/message-id/40A1375C.1080806@turtle-entertainment.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bm@turtle-entertainment.de, adave@vantage.com, pgsql-admin@postgresql.org
  Subject: Re: [PERFORM] Quad processor options
  In-Reply-To: <40A1375C.1080806@turtle-entertainment.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox