Re: How to improve db performance with $7K?
От | Tom Lane |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 1568.1113497083@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: How to improve db performance with $7K? ("Matthew Nuzum") |
Список | 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", )
"Matthew Nuzum" <> writes: > So if you all were going to choose between two hard drives where: > drive A has capacity C and spins at 15K rpms, and > drive B has capacity 2 x C and spins at 10K rpms and > all other features are the same, the price is the same and C is enough > disk space which would you choose? > I've noticed that on IDE drives, as the capacity increases the data > density increases and there is a pereceived (I've not measured it) > performance increase. > Would the increased data density of the higher capacity drive be of > greater benefit than the faster spindle speed of drive A? Depends how they got the 2x capacity increase. If they got it by increased bit density --- same number of tracks, but more sectors per track --- then drive B actually has a higher transfer rate, because in one rotation it can transfer twice as much data as drive A. More tracks per cylinder (ie, more platters) can also be a speed win since you can touch more data before you have to seek to another cylinder. Drive B will lose if the 2x capacity was all from adding cylinders (unless its seek-time spec is way better than A's ... which is unlikely but not impossible, considering the cylinders are probably closer together). Usually there's some-of-each involved, so it's hard to make any definite statement without more facts. regards, tom lane
В списке pgsql-performance по дате отправления: