Re: Any better plan for this query?..

Список

Период

Сортировка

От	Simon Riggs
Тема	Re: Any better plan for this query?..
Дата	12 мая 2009 г. 10:47:22
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, 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 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 по дате отправления:

Предыдущее

От: Dimitri
Дата: 12 мая 2009 г., 10:17:04
Сообщение: Re: Any better plan for this query?..

Следующее

От: Tom Lane
Дата: 12 мая 2009 г., 10:49:56
Сообщение: Re: Any better plan for this query?..