On Sun, 27 Nov 2005, Luke Lonergan wrote:
For data warehousing its pretty well open and shut. To use all cpus and
io channels on each query you will need mpp.
Has anyone done the math.on the original post? 5TB takes how long to
scan once? If you want to wait less than a couple of days just
For data warehousing its pretty well open and shut. To use all cpus and io
channels on each query you will need mpp.
Has anyone done the math.on the original post? 5TB takes how long to scan
once? If you want to wait less than a couple of days just for a seq scan,
you'd better be in the mult
Another thought - I priced out a maxed out machine with 16 cores and
128GB of RAM and 1.5TB of usable disk - $71,000.
You could instead buy 8 machines that total 16 cores, 128GB RAM and 28TB
of disk for $48,000, and it would be 16 times faster in scan rate, which
is the most important factor for
These boxes don't look like being designed for a DB server. The first are
very CPU bound, and the third may be a good choice for very large amounts
of streamed data, but not optimal for TP random access.
I don't know what you mean when you say that the first ones are CPU bound,
they have far m
by the way, this is the discussion that promped me to start this project
http://lwn.net/Articles/161323/
David Lang
---(end of broadcast)---
TIP 6: explain analyze is your friend
Ok, I've subscribed (hopefully list volume won't kill me :-)
I'm covering several things in this message since I didn't receive the
prior messages in the thread
first off these benchamrks are not being sponsered by my employer, they
need the machines burned in and so I'm going to use them for
Qingqing Zhou wrote:
"Jeff Frost" <[EMAIL PROTECTED]> wrote
"The hardware I have available is as follows:
* 2x dual Opteron 8G ram, 2x144G 15Krpm SCSI
* 2x dual Opteron 8G ram, 2x72G 15Krpm SCSI
* 1x dual Opteron 16G ram, 2x36G 15Krpm SCSI 16x400G 7200rpm SATA
(2) The hardware confi
At 03:15 PM 11/26/2005, Luke Lonergan wrote:
I suggest specifying a set of basic system / HW benchmarks to baseline the
hardware before each benchmark is run. This has proven to be a major issue
with most performance tests. My pick for I/O is bonnie++.
Your equipment allows you the opportunit
Jeff, Qingqing,
On 11/26/05 10:57 AM, "Qingqing Zhou" <[EMAIL PROTECTED]> wrote:
>
> "Jeff Frost" <[EMAIL PROTECTED]> wrote
>>
>> Did you folks see this article on Slashdot with a fellow requesting input
>> on what sort of benchmarks to run to get a good Postgresql vs Mysql
>> dataset? Perhaps
"Jeff Frost" <[EMAIL PROTECTED]> wrote
>
> Did you folks see this article on Slashdot with a fellow requesting input
> on what sort of benchmarks to run to get a good Postgresql vs Mysql
> dataset? Perhaps this would be a good opportunity for us to get some good
> benchmarking done.
> "The har
Did you folks see this article on Slashdot with a fellow requesting input on
what sort of benchmarks to run to get a good Postgresql vs Mysql dataset?
Perhaps this would be a good opportunity for us to get some good benchmarking
done. Here's the article link and top text:
http://ask.slashdot.
11 matches
Mail list logo
