Re: How to improve db performance with $7K?
От | Tom Lane |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 13449.1112847297@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: How to improve db performance with $7K? (Greg Stark) |
Ответы |
Re: How to improve db performance with $7K?
(Kevin Brown)
|
Список | 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", )
Greg Stark <> writes: > In any case the issue with the IDE protocol is that fundamentally you > can only have a single command pending. SCSI can have many commands > pending. That's the bottom line: the SCSI protocol was designed (twenty years ago!) to allow the drive to do physical I/O scheduling, because the CPU can issue multiple commands before the drive has to report completion of the first one. IDE isn't designed to do that. I understand that the latest revisions to the IDE/ATA specs allow the drive to do this sort of thing, but support for it is far from widespread. regards, tom lane
В списке pgsql-performance по дате отправления:
Следующее
От: Harald FuchsДата:
Сообщение: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)