Re: Proposal of tunable fix for scalability of 8.4
От | Alvaro Herrera |
---|---|
Тема | Re: Proposal of tunable fix for scalability of 8.4 |
Дата | |
Msg-id | 20090320220513.GS8313@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera) |
Ответы |
Re: Proposal of tunable fix for scalability of 8.4
("Jignesh K. Shah")
|
Список | pgsql-performance |
Дерево обсуждения
Proposal of tunable fix for scalability of 8.4
("Jignesh K. Shah",
)
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Josh Berkus, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Alan Stange, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Grzegorz Jaśkiewicz, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Ron, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Josh Berkus, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Alan Stange, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Grzegorz Jaśkiewicz, )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", )
Re: Proposal of tunable fix for scalability of 8.4 (Ron, )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", )
Alvaro Herrera escribió: > So Simon's correct. And perhaps this explains why Jignesh is measuring an improvement on his benchmark. Perhaps an useful experiment would be to turn this behavior off and compare performance. This lack of measurement is probably the cause that the suggested patch to fix it was never applied. The patch is here http://archives.postgresql.org//pgsql-hackers/2004-11/msg00935.php -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-performance по дате отправления: