Re: How to improve db performance with $7K?
От | Steve Poe |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 4244A90B.2030200@sfnet.cc обсуждение исходный текст |
Ответ на | Re: How to improve db performance with $7K? ("Joshua D. Drake") |
Ответы |
Re: How to improve db performance with $7K?
(Bjoern Metzdorf)
Re: How to improve db performance with $7K? (PFC) |
Список | 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", )
You could build a dual opteron with 4 GB of ram, 12 10k raptor SATA drives with a battery backed cache for about 7k or less. Okay. You trust SATA drives? I've been leary of them for a production database. Pardon my ignorance, but what is a "battery backed cache"? I know the drives have a built-in cache but I don't if that's the same. Are the 12 drives internal or an external chasis? Could you point me to a place that this configuration exist? > > Or if they are not CPU bound just IO bound you could easily just > add an external 12 drive array (even if scsi) for less than 7k. > I don't believe it is CPU bound. At our busiest hour, the CPU is idle about 70% on average down to 30% idle at its heaviest. Context switching averages about 4-5K per hour with momentary peaks to 25-30K for a minute. Overall disk performance is poor (35mb per sec). Thanks for your input. Steve Poe
В списке pgsql-performance по дате отправления: