Re: How to improve db performance with $7K?
От | Jim C. Nasby |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 20050420001224.GT58835@decibel.org обсуждение исходный текст |
Ответ на | Re: How to improve db performance with $7K? ("Mohan, Ross") |
Ответы |
Re: How to improve db performance with $7K?
(Alex Turner)
|
Список | 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", )
On Mon, Apr 18, 2005 at 06:41:37PM -0000, Mohan, Ross wrote: > Don't you think "optimal stripe width" would be > a good question to research the binaries for? I'd > think that drives the answer, largely. (uh oh, pun alert) > > EG, oracle issues IO requests (this may have changed _just_ > recently) in 64KB chunks, regardless of what you ask for. > So when I did my striping (many moons ago, when the Earth > was young...) I did it in 128KB widths, and set the oracle > "multiblock read count" according. For oracle, any stripe size > under 64KB=stupid, anything much over 128K/258K=wasteful. > > I am eager to find out how PG handles all this. AFAIK PostgreSQL requests data one database page at a time (normally 8k). Of course the OS might do something different. -- Jim C. Nasby, Database Consultant 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?"
В списке pgsql-performance по дате отправления:
Предыдущее
От: "J. Andrew Rogers"Дата:
Сообщение: Re: Opteron vs Xeon (Was: What to do with 6 disks?)