Re: Any better plan for this query?..
От | Matthew Wakeling |
---|---|
Тема | Re: Any better plan for this query?.. |
Дата | |
Msg-id | alpine.DEB.2.00.0905061527410.2341@aragorn.flymine.org обсуждение исходный текст |
Ответ на | Re: Any better plan for this query?.. (Kenneth Marshall) |
Список | 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 Wed, May 06, 2009 at 10:04:33PM +0800, Craig Ringer wrote: >> Can the genetic query optimizer come into play on small queries? On Wed, 6 May 2009, Kenneth Marshall wrote: > No. Yes. But you would have had to have set some really weird configuration. Matthew -- And the lexer will say "Oh look, there's a null string. Oooh, there's another. And another.", and will fall over spectacularly when it realises there are actually rather a lot. - Computer Science Lecturer (edited)
В списке pgsql-performance по дате отправления:
Следующее
От: Simon RiggsДата:
Сообщение: Re: Transparent table partitioning in future version of PG?