I say most apps because it's true. :) I would suggest that pretty much
every app (other than video/audio streaming) people think are
bandwidth-limited are actually latency-limited. Take the SpecFoo tests.
Sure I would have rather seen SAP/TPC/etc that would be more relevant to
Postgres but ther
William Yu <[EMAIL PROTECTED]> writes:
> It turns out the latency in a 2xDC setup is just so much lower and most apps
> like lower latency than higher bandwidth.
You haven't tested anything about "most apps". You tested what the SpecFoo
apps prefer. If you're curious about which Postgres prefers
4-way SMP Opteron system is actually pretty damn cheap -- if you get
2xDual Core versus 4xSingle. I just ordered a 2x265 (4x1.8ghz) system
and the price was about $1300 more than a 2x244 (2x1.8ghz).
Now you might ask, is a 2xDC comparable to 4x1? Here's some benchmarks
I've found that showing D
> This can often be called for. I'm working on a 400GB data warehouse right
> now, and almost *all* of our queries run from materialized aggregate tables.
I thought that was pretty much the definition of data warehousing! :-)
--
Mike Nolan
---(end of broadcast)-
Joel,
> The two worst queries (our case and audit applications) I created
> denormalized files and maintain them through code. All reporting comes off
> those and it is lightning fast.
This can often be called for. I'm working on a 400GB data warehouse right
now, and almost *all* of our queries
sage-
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 7:03 PM
To: Joel Fradkin
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] ok you all win what is best opteron (I dont want a
hosed system again)
Joel Fradkin wrote:
> Is the battery backed cache good or
Joel Fradkin wrote:
Is the battery backed cache good or bad for Postgres?
Battery-backed avoids corruption if you have an unexpected power loss.
It's considered mandatory with large-cache write-back controllers if you
can't afford to lose any data.
They are telling me I can only get a duel chann
Joel wrote:
I have been following threads (in case you don't know I bought a 4 proc
Dell recently) and the Opteron seems the way to go.
I just called HP for a quote, but don't want to make any mistakes.
[snip]
At your level of play it's the DL585.
Have you checked out http://www.swt.com?
Merlin
