Re: Any better plan for this query?..
От | Simon Riggs |
---|---|
Тема | Re: Any better plan for this query?.. |
Дата | |
Msg-id | 1242125339.3843.226.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: Any better plan for this query?.. (Dimitri) |
Ответы |
Re: Any better plan for this query?..
(Dimitri)
|
Список | pgsql-performance |
Дерево обсуждения
Any better plan for this query?..
(Dimitri,
)
Re: Any better plan for this query?.. (Craig Ringer, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Chris, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. (Craig Ringer, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Aidan Van Dyk, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. ("Dave Dutcher", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Andres Freund, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Gregory Stark, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Greg Stark, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Aidan Van Dyk, )
Re: Any better plan for this query?.. (Stephen Frost, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Glenn Maynard, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. ("Albe Laurenz", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. (Ries van Twisk, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Craig Ringer, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Chris, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. (Craig Ringer, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Aidan Van Dyk, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. ("Dave Dutcher", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Heikki Linnakangas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Andres Freund, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Scott Carey, )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Gregory Stark, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. (Matthew Wakeling, )
Re: Any better plan for this query?.. (Tom Lane, )
Re: Any better plan for this query?.. (Greg Stark, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Simon Riggs, )
Re: Any better plan for this query?.. ("Joshua D. Drake", )
Re: Any better plan for this query?.. (Aidan Van Dyk, )
Re: Any better plan for this query?.. (Stephen Frost, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Glenn Maynard, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. ("Kevin Grittner", )
Re: Any better plan for this query?.. (Dimitri Fontaine, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Robert Haas, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. ("Albe Laurenz", )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Merlin Moncure, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Richard Huxton, )
Re: Any better plan for this query?.. (Ries van Twisk, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Kenneth Marshall, )
Re: Any better plan for this query?.. (Dimitri, )
Re: Any better plan for this query?.. (Alvaro Herrera, )
Re: Any better plan for this query?.. (Simon Riggs, )
On Tue, 2009-05-12 at 12:19 +0200, Dimitri wrote: > For my big surprise, MySQL was faster! Ours too. ** I bet you $1000 that I can improve the performance of your benchmark results with PostgreSQL. You give me $1000 up-front and if I can't improve your high end numbers I'll give you $2000 back. Either way, you name me and link to me from your blog. Assuming you re-run the tests as requested and give me reasonable access to info and measurements. ** I note your blog identifies you as a Sun employee. Is that correct? If you do not give us the opportunity to improve upon the results then reasonable observers might be persuaded you did not wish to show PostgreSQL in its best light. You up for it? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
В списке pgsql-performance по дате отправления: