| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | rainer(at)lisim(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance question |
| Date: | 2005-05-24 14:54:23 |
| Message-ID: | 1116946463.31821.272.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2005-05-23 at 14:07, LiSim: Rainer Mokros wrote:
> Hello,
> Anyone has try to install Postgres on a AMT Opteron (Dual Core) box with 4
> CPU’s and 64GB main memory and 3 TB Raid 10 (24 disks) Linux (2.6), to run a
> datawarehouse of 1TB.
> Any points
No, but if you buy my ticket I'd fly out and install it for free just to
play on such a machine for an afternoon. Seriously.
For that many CPUs, you might want to try running the latest snapshot or
daily CVS tip, as Tom made some changes that seem to really increase
performance on larger SMP systems.
For performance tuning, look at the tuning guide on varlena first:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
I'd also make sure you're getting the best RAID controller you can
afford, with a reliable and fast driver for your OS.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastian Böck | 2005-05-24 15:05:34 | Update on tables when the row doesn't change |
| Previous Message | Tom Lane | 2005-05-24 14:33:00 | Re: Need input on postgres used for phpBB |