Yet another postgres scaling question (use on AMD Opteron)

From: "Fred Moyer" <fred(at)digicamp(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>, <psql-performance(at)postgresql(dot)org>
Subject: Yet another postgres scaling question (use on AMD Opteron)
Date: 2003-05-31 20:05:54
Message-ID: 35662.168.103.211.140.1054411554.squirrel@mail.digicamp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

I am looking for feedback on the AMD Opteron based platform as a server
for Postgres, and also comments. The databases I am looking at will
likely have aggregate sums of indexes larger than the amount of memory on
a 32 bit machine, so I am looking at 64-bit platforms.

Does anyone here have experience with use of the Opteron platform? There
was a post a while ago by someone asking if it would run on a Beowolf
cluster of opterons ( indicated it won't ) but I am interested in knowing
if anyone has actually implemented it on an Opteron machine. It should
work since Opteron runs linux, but knowing that it _is_ in production
somewhere would give me more leverage to get an implementation plan
approved. I know that many here have used Sun and IBM to scale postgres
but looking at the cost, Opteron is the most attractive right now.

The database sizes I am looking at are in the realm of 5-50 gigabytes. So
far I have been able to achieve acceptable speeds on a 2 gigabyte database
with a 32 bit machine, but as the data size grows an argument has been
introduced that going with MySQL would allow us to scale with smaller
machines (hold the flames please :). I have optimized and tuned the
hardware and database according to the fine advice given on these lists
(especially according to the kernel cache/shared buffer cache balancing
threads).

Comments and suggestions greatly appreciated.

Thanks

Fred Moyer

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-31 20:36:34 Re: Yet another postgres scaling question (use on AMD Opteron)
Previous Message lexx 2003-05-31 11:20:48 defined max length