Re: Any better plan for this query?..

Список

Период

Сортировка

От	Matthew Wakeling
Тема	Re: Any better plan for this query?..
Дата	6 мая 2009 г. 14:29:38
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, 06 мая 2009 г., 07:42:03 )
Re: Any better plan for this query?.. (Craig Ringer, 06 мая 2009 г., 08:12:53 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 08:18:09 )
Re: Any better plan for this query?.. (Chris, 06 мая 2009 г., 08:24:07 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 08:33:53 )
Re: Any better plan for this query?.. (Richard Huxton, 06 мая 2009 г., 08:54:23 )
Re: Any better plan for this query?.. (Craig Ringer, 06 мая 2009 г., 14:05:04 )
Re: Any better plan for this query?.. (Kenneth Marshall, 06 мая 2009 г., 14:26:46 )
Re: Any better plan for this query?.. (Matthew Wakeling, 06 мая 2009 г., 14:29:38 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 14:31:41 )
Re: Any better plan for this query?.. (Kenneth Marshall, 06 мая 2009 г., 12:59:04 )
Re: Any better plan for this query?.. (Heikki Linnakangas, 06 мая 2009 г., 08:21:16 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 08:33:17 )
Re: Any better plan for this query?.. (Simon Riggs, 06 мая 2009 г., 21:34:48 )
Re: Any better plan for this query?.. (Dimitri, 07 мая 2009 г., 08:20:51 )
Re: Any better plan for this query?.. (Merlin Moncure, 07 мая 2009 г., 11:35:01 )
Re: Any better plan for this query?.. (Dimitri, 07 мая 2009 г., 18:37:03 )
Re: Any better plan for this query?.. (Simon Riggs, 07 мая 2009 г., 19:53:57 )
Re: Any better plan for this query?.. (Dimitri, 11 мая 2009 г., 15:18:40 )
Re: Any better plan for this query?.. (Tom Lane, 11 мая 2009 г., 15:24:17 )
Re: Any better plan for this query?.. (Dimitri, 11 мая 2009 г., 16:30:21 )
Re: Any better plan for this query?.. (Simon Riggs, 11 мая 2009 г., 19:01:14 )
Re: Any better plan for this query?.. (Merlin Moncure, 11 мая 2009 г., 17:46:50 )
Re: Any better plan for this query?.. (Simon Riggs, 11 мая 2009 г., 18:56:22 )
Re: Any better plan for this query?.. (Dimitri, 11 мая 2009 г., 22:30:52 )
Re: Any better plan for this query?.. (Aidan Van Dyk, 11 мая 2009 г., 19:46:20 )
Re: Any better plan for this query?.. (Dimitri, 11 мая 2009 г., 22:46:59 )
Re: Any better plan for this query?.. (Alvaro Herrera, 11 мая 2009 г., 22:54:52 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 07:35:27 )
Re: Any better plan for this query?.. (Dimitri Fontaine, 12 мая 2009 г., 08:45:17 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 10:19:11 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 10:47:22 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 11:16:13 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 11:31:34 )
Re: Any better plan for this query?.. (Heikki Linnakangas, 12 мая 2009 г., 11:35:41 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 12:29:57 )
Re: Any better plan for this query?.. (Simon Riggs, 14 мая 2009 г., 17:03:19 )
Re: Any better plan for this query?.. (Dimitri, 14 мая 2009 г., 18:25:43 )
Re: Any better plan for this query?.. (Simon Riggs, 18 мая 2009 г., 15:07:07 )
Re: Any better plan for this query?.. (Dimitri, 18 мая 2009 г., 18:01:05 )
Re: Any better plan for this query?.. (Simon Riggs, 18 мая 2009 г., 19:25:42 )
Re: Any better plan for this query?.. ("Dave Dutcher", 18 мая 2009 г., 20:44:40 )
Re: Any better plan for this query?.. (Dimitri, 18 мая 2009 г., 22:32:47 )
Re: Any better plan for this query?.. (Merlin Moncure, 19 мая 2009 г., 13:35:17 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 16:00:59 )
Re: Any better plan for this query?.. (Merlin Moncure, 19 мая 2009 г., 17:38:16 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 19:15:19 )
Re: Any better plan for this query?.. (Merlin Moncure, 19 мая 2009 г., 21:48:57 )
Re: Any better plan for this query?.. (Dimitri, 18 мая 2009 г., 22:33:25 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 07:24:05 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 10:52:00 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 12:00:48 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 13:33:43 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 14:59:47 )
Re: Any better plan for this query?.. (Tom Lane, 18 мая 2009 г., 23:10:00 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 10:30:43 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 10:55:33 )
Re: Any better plan for this query?.. (Matthew Wakeling, 19 мая 2009 г., 11:18:01 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 11:34:35 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 11:39:07 )
Re: Any better plan for this query?.. (Matthew Wakeling, 19 мая 2009 г., 12:02:14 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 16:20:25 )
Re: Any better plan for this query?.. (Scott Carey, 19 мая 2009 г., 16:38:32 )
Re: Any better plan for this query?.. (Robert Haas, 19 мая 2009 г., 14:01:01 )
Re: Any better plan for this query?.. (Tom Lane, 19 мая 2009 г., 13:32:05 )
Re: Any better plan for this query?.. (Simon Riggs, 19 мая 2009 г., 16:10:21 )
Re: Any better plan for this query?.. (Tom Lane, 19 мая 2009 г., 22:49:58 )
Re: Any better plan for this query?.. (Robert Haas, 20 мая 2009 г., 04:01:00 )
Re: Any better plan for this query?.. (Simon Riggs, 20 мая 2009 г., 08:09:57 )
Re: Any better plan for this query?.. (Robert Haas, 20 мая 2009 г., 11:17:34 )
Re: Any better plan for this query?.. (Simon Riggs, 20 мая 2009 г., 11:50:30 )
Re: Any better plan for this query?.. (Scott Carey, 18 мая 2009 г., 19:37:57 )
Re: Any better plan for this query?.. (Dimitri, 18 мая 2009 г., 22:32:58 )
Re: Any better plan for this query?.. (Scott Carey, 19 мая 2009 г., 01:01:35 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 10:46:51 )
Re: Any better plan for this query?.. (Scott Carey, 19 мая 2009 г., 17:13:34 )
Re: Any better plan for this query?.. (Dimitri, 19 мая 2009 г., 18:59:18 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 11:48:02 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 12:59:10 )
Re: Any better plan for this query?.. (Robert Haas, 12 мая 2009 г., 14:49:05 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 15:30:37 )
Re: Any better plan for this query?.. ("Kevin Grittner", 12 мая 2009 г., 15:46:54 )
Re: Any better plan for this query?.. ("Joshua D. Drake", 12 мая 2009 г., 16:09:02 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 16:17:04 )
Re: Any better plan for this query?.. (Robert Haas, 13 мая 2009 г., 02:55:07 )
Re: Any better plan for this query?.. (Dimitri, 13 мая 2009 г., 10:48:59 )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, 12 мая 2009 г., 12:38:43 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 13:33:03 )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, 12 мая 2009 г., 14:34:57 )
Re: Any better plan for this query?.. (Matthew Wakeling, 12 мая 2009 г., 15:00:26 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 15:02:26 )
Re: Any better plan for this query?.. (Matthew Wakeling, 12 мая 2009 г., 15:05:52 )
Re: Any better plan for this query?.. (Stefan Kaltenbrunner, 12 мая 2009 г., 15:14:56 )
Re: Any better plan for this query?.. (Tom Lane, 12 мая 2009 г., 15:18:39 )
Re: Any better plan for this query?.. (Robert Haas, 13 мая 2009 г., 14:45:00 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 16:01:13 )
Re: Any better plan for this query?.. ("Joshua D. Drake", 13 мая 2009 г., 00:40:57 )
Re: Any better plan for this query?.. (Heikki Linnakangas, 12 мая 2009 г., 05:11:53 )
Re: Any better plan for this query?.. (Dimitri, 12 мая 2009 г., 07:36:47 )
Re: Any better plan for this query?.. (Andres Freund, 12 мая 2009 г., 07:53:30 )
Re: Any better plan for this query?.. (Alvaro Herrera, 12 мая 2009 г., 17:54:19 )
Re: Any better plan for this query?.. (Scott Carey, 12 мая 2009 г., 23:24:29 )
Re: Any better plan for this query?.. (Dimitri, 13 мая 2009 г., 10:22:11 )
Re: Any better plan for this query?.. (Scott Carey, 13 мая 2009 г., 16:42:47 )
Re: Any better plan for this query?.. (Dimitri Fontaine, 13 мая 2009 г., 21:23:36 )
Re: Any better plan for this query?.. (Dimitri, 14 мая 2009 г., 18:28:26 )
Re: Any better plan for this query?.. (Simon Riggs, 18 мая 2009 г., 15:09:29 )
Re: Any better plan for this query?.. (Dimitri, 14 мая 2009 г., 18:34:53 )
Re: Any better plan for this query?.. (Gregory Stark, 07 мая 2009 г., 11:58:59 )
Re: Any better plan for this query?.. (Simon Riggs, 07 мая 2009 г., 12:20:13 )
Re: Any better plan for this query?.. (Matthew Wakeling, 06 мая 2009 г., 09:36:08 )
Re: Any better plan for this query?.. (Tom Lane, 12 мая 2009 г., 16:49:56 )
Re: Any better plan for this query?.. (Greg Stark, 12 мая 2009 г., 23:59:53 )
Re: Any better plan for this query?.. (Robert Haas, 13 мая 2009 г., 03:24:27 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 21:01:54 )
Re: Any better plan for this query?.. ("Joshua D. Drake", 12 мая 2009 г., 23:27:21 )
Re: Any better plan for this query?.. (Aidan Van Dyk, 13 мая 2009 г., 00:50:47 )
Re: Any better plan for this query?.. (Stephen Frost, 13 мая 2009 г., 02:18:05 )
Re: Any better plan for this query?.. (Robert Haas, 12 мая 2009 г., 23:49:01 )
Re: Any better plan for this query?.. (Glenn Maynard, 13 мая 2009 г., 03:26:46 )
Re: Any better plan for this query?.. (Dimitri, 13 мая 2009 г., 10:29:28 )
Re: Any better plan for this query?.. ("Kevin Grittner", 13 мая 2009 г., 14:53:06 )
Re: Any better plan for this query?.. (Dimitri, 13 мая 2009 г., 16:16:34 )
Re: Any better plan for this query?.. ("Kevin Grittner", 13 мая 2009 г., 17:06:26 )
Re: Any better plan for this query?.. (Dimitri Fontaine, 12 мая 2009 г., 23:21:01 )
Re: Any better plan for this query?.. (Alvaro Herrera, 12 мая 2009 г., 23:55:44 )
Re: Any better plan for this query?.. (Robert Haas, 12 мая 2009 г., 23:35:05 )
Re: Any better plan for this query?.. (Dimitri, 13 мая 2009 г., 10:02:55 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 08:52:00 )
Re: Any better plan for this query?.. (Richard Huxton, 06 мая 2009 г., 09:06:16 )
Re: Any better plan for this query?.. ("Albe Laurenz", 06 мая 2009 г., 12:29:54 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 12:49:27 )
Re: Any better plan for this query?.. (Kenneth Marshall, 06 мая 2009 г., 13:05:16 )
Re: Any better plan for this query?.. (Merlin Moncure, 06 мая 2009 г., 11:46:30 )
Re: Any better plan for this query?.. (Merlin Moncure, 06 мая 2009 г., 11:47:27 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 12:33:20 )
Re: Any better plan for this query?.. (Richard Huxton, 06 мая 2009 г., 12:53:56 )
Re: Any better plan for this query?.. (Ries van Twisk, 06 мая 2009 г., 13:29:19 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 14:03:48 )
Re: Any better plan for this query?.. (Kenneth Marshall, 06 мая 2009 г., 14:34:57 )
Re: Any better plan for this query?.. (Dimitri, 06 мая 2009 г., 14:48:28 )
Re: Any better plan for this query?.. (Kenneth Marshall, 06 мая 2009 г., 15:49:25 )
Re: Any better plan for this query?.. (Dimitri, 07 мая 2009 г., 08:49:14 )
Re: Any better plan for this query?.. (Alvaro Herrera, 07 мая 2009 г., 15:27:12 )
Re: Any better plan for this query?.. (Simon Riggs, 12 мая 2009 г., 18:53:51 )

> 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 по дате отправления:

Предыдущее

От: Kenneth Marshall
Дата: 06 мая 2009 г., 09:49:25
Сообщение: Re: Any better plan for this query?..

Следующее

От: Simon Riggs
Дата: 06 мая 2009 г., 15:32:15
Сообщение: Re: Transparent table partitioning in future version of PG?