Re: How to improve db performance with $7K?
От | Dave Held |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 49E94D0CFCD4DB43AFBA928DDD20C8F9026184B5@asg002.asg.local обсуждение исходный текст |
Ответ на | How to improve db performance with $7K? (Steve Poe) |
Ответы |
Re: How to improve db performance with $7K?
("Jim C. Nasby")
|
Список | pgsql-performance |
Дерево обсуждения
How to improve db performance with $7K?
(Steve Poe,
)
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Will LaShell, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Bjoern Metzdorf, )
Re: How to improve db performance with $7K? (Josh Berkus, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Cott Lang, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Cott Lang, )
Follow-Up: How to improve db performance with $7K? (Steve Poe, )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, )
Re: Follow-Up: How to improve db performance with $7K? (Kevin Brown, )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, )
Re: Follow-Up: How to improve db performance with $7K? (Vivek Khera, )
Re: Follow-Up: How to improve db performance with $7K? (Will LaShell, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: Follow-Up: How to improve db performance with $7K? (PFC, )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Dave Cramer, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Matthew Nuzum, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Rosser Schwarz, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alvaro Herrera, )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Alan Stange, )
Re: How to improve db performance with $7K? (Dave Cramer, )
Re: How to improve db performance with $7K? ("Alexander Kirpa", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Matthew Nuzum", )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alan Stange, )
Re: How to improve db performance with $7K? (John A Meinel, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
What to do with 6 disks? (Jeff Frost, )
Re: What to do with 6 disks? ("Jim C. Nasby", )
Re: What to do with 6 disks? (Josh Berkus, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) ("J. Andrew Rogers", )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (William Yu, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Vivek Khera, )
Re: What to do with 6 disks? (Vivek Khera, )
Re: What to do with 6 disks? (William Yu, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (Dawid Kuroczko, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Will LaShell, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Bjoern Metzdorf, )
Re: How to improve db performance with $7K? (Josh Berkus, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Cott Lang, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Cott Lang, )
Follow-Up: How to improve db performance with $7K? (Steve Poe, )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, )
Re: Follow-Up: How to improve db performance with $7K? (Kevin Brown, )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, )
Re: Follow-Up: How to improve db performance with $7K? (Vivek Khera, )
Re: Follow-Up: How to improve db performance with $7K? (Will LaShell, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: Follow-Up: How to improve db performance with $7K? (PFC, )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Dave Cramer, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Vivek Khera, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Matthew Nuzum, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Rosser Schwarz, )
Re: How to improve db performance with $7K? (Kevin Brown, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alvaro Herrera, )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Alan Stange, )
Re: How to improve db performance with $7K? (Dave Cramer, )
Re: How to improve db performance with $7K? ("Alexander Kirpa", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Matthew Nuzum", )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (PFC, )
Re: How to improve db performance with $7K? (Tom Lane, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? (Greg Stark, )
Re: How to improve db performance with $7K? (Alan Stange, )
Re: How to improve db performance with $7K? (John A Meinel, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Joshua D. Drake", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Steve Poe, )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (Jacques Caron, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? (Alex Turner, )
Re: How to improve db performance with $7K? (William Yu, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (, )
Re: How to improve db performance with $7K? ("Jim C. Nasby", )
What to do with 6 disks? (Jeff Frost, )
Re: What to do with 6 disks? ("Jim C. Nasby", )
Re: What to do with 6 disks? (Josh Berkus, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) ("J. Andrew Rogers", )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (William Yu, )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Vivek Khera, )
Re: What to do with 6 disks? (Vivek Khera, )
Re: What to do with 6 disks? (William Yu, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? (Bruce Momjian, )
Re: How to improve db performance with $7K? (Dawid Kuroczko, )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
Re: How to improve db performance with $7K? ("Dave Held", )
Re: How to improve db performance with $7K? ("Mohan, Ross", )
> -----Original Message----- > From: Greg Stark [mailto:] > Sent: Monday, April 18, 2005 9:59 AM > To: William Yu > Cc: > Subject: Re: [PERFORM] How to improve db performance with $7K? > > William Yu <> writes: > > > Using the above prices for a fixed budget for RAID-10, you > > could get: > > > > SATA 7200 -- 680MB per $1000 > > SATA 10K -- 200MB per $1000 > > SCSI 10K -- 125MB per $1000 > > 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
В списке pgsql-performance по дате отправления: