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:
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 hardware I
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 this would be a
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
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
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
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
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
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
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
10 matches
Mail list logo
