Re: [PERFORM] Quad processor options

Поиск
Список
Период
Сортировка
Искать

Re: [PERFORM] Quad processor options

От:
"Anjan Dave" <adave@vantage.com>
Дата:
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.
 
I am actually curious, have you researched/attempted any postgresql clustering solutions? I agree, you can't just keep buying bigger machines.
 
They have 5 internal drives (4 in RAID 10, 1 spare) on U320, 128MB cache on the PERC controller, 8GB RAM.
 
Thanks,
Anjan

	-----Original Message----- 
	From: Bjoern Metzdorf [mailto:bm@turtle-entertainment.de] 
	Sent: Tue 5/11/2004 3:06 PM 
	To: pgsql-performance@postgresql.org 
	Cc: Pgsql-Admin (E-mail) 
	Subject: [PERFORM] Quad processor options
	
	

	Hi,
	
	I am curious if there are any real life production quad processor setups
	running postgresql out there. Since postgresql lacks a proper
	replication/cluster solution, we have to buy a bigger machine.
	
	Right now we are running on a dual 2.4 Xeon, 3 GB Ram and U160 SCSI
	hardware-raid 10.
	
	Has anyone experiences with quad Xeon or quad Opteron setups? I am
	looking at the appropriate boards from Tyan, which would be the only
	option for us to buy such a beast. The 30k+ setups from Dell etc. don't
	fit our budget.
	
	I am thinking of the following:
	
	Quad processor (xeon or opteron)
	5 x SCSI 15K RPM for Raid 10 + spare drive
	2 x IDE for system
	ICP-Vortex battery backed U320 Hardware Raid
	4-8 GB Ram
	
	Would be nice to hear from you.
	
	Regards,
	Bjoern
	
	---------------------------(end of broadcast)---------------------------
	TIP 4: Don't 'kill -9' the postmaster
	

Re: [PERFORM] Quad processor options

От:
Bjoern Metzdorf <bm@turtle-entertainment.de>
Дата:
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
FAQ