|
Home > Archive > PostgreSQL Performance > April 2005 > Re: How to improve db performance with $7K?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: How to improve db performance with $7K?
|
|
| Dave Held 2005-04-18, 11:24 am |
| > -----Original Message-----
> From: Greg Stark [mailto:gsstark@mit.edu]
> Sent: Monday, April 18, 2005 9:59 AM
> To: William Yu
> Cc: pgsql- performance@postgres
ql.org
> Subject: Re: [PERFORM] How to improve db performance with $7K?
>
> William Yu <wyu@talisys.com> writes:
>
>
> What a lot of these analyses miss is that cheaper == faster
> because cheaper means you can buy more spindles for the same
> price. I'm assuming you picked equal sized drives to compare
> so that 200MB/$1000 for SATA is almost twice as many spindles
> as the 125MB/$1000. That means it would have almost double
> the bandwidth. And the 7200 RPM case would have more than 5x
> the bandwidth.
> [...]
Hmm...so you're saying that at some point, quantity beats quality?
That's an interesting point. However, it presumes that you can
actually distribute your data over a larger number of drives. If
you have a db with a bottleneck of one or two very large tables,
the extra spindles won't help unless you break up the tables and
glue them together with query magic. But it's still a point to
consider.
__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
| |
| Jim C. Nasby 2005-04-19, 8:24 pm |
| On Mon, Apr 18, 2005 at 10:20:36AM -0500, Dave Held wrote:
> Hmm...so you're saying that at some point, quantity beats quality?
> That's an interesting point. However, it presumes that you can
> actually distribute your data over a larger number of drives. If
> you have a db with a bottleneck of one or two very large tables,
> the extra spindles won't help unless you break up the tables and
> glue them together with query magic. But it's still a point to
> consider.
Huh? Do you know how RAID10 works?
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
|
|
|
|