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