Re: Proposal of tunable fix for scalability of 8.4
От | Bruce Momjian |
---|---|
Тема | Re: Proposal of tunable fix for scalability of 8.4 |
Дата | |
Msg-id | 200903191737.n2JHbZU15353@momjian.us обсуждение исходный текст |
Ответ на | Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas) |
Ответы |
Re: Proposal of tunable fix for scalability of 8.4
(Scott Carey)
|
Список | 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", )
Robert Haas wrote: > > The original poster's request is for a config parameter, for experimentation > > and testing by the brave. My own request was for that version of the lock to > > prevent possible starvation but improve performance by unlocking all shared > > at once, then doing all exclusives one at a time next, etc. > > That doesn't prevent starvation in general, although it will for some workloads. > > Anyway, it seems rather pointless to add a config parameter that isn't > at all safe, and adds overhead to a critical part of the system for > people who don't use it. After all, if you find that it helps, what > are you going to do? Turn it on in production? I just don't see how > this is any good other than as a thought-experiment. We prefer things to be auto-tuned, and if not, it should be clear how/when to set the configuration parameter. -- Bruce Momjian <> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
В списке pgsql-performance по дате отправления: