Re: Any better plan for this query?..

From:	Merlin Moncure <mmoncure(at)gmail(dot)com>
To:	Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
Cc:	PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Any better plan for this query?..
Date:	2009-05-06 11:47:22
Message-ID:	b42b73150905060447q48695d2fybf9f517c286bf973@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2009-05-06 07:38:59 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>  2009-05-06 08:01:03 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>   2009-05-06 08:14:38 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>    2009-05-06 08:22:27 from Chris <dmagick(at)gmail(dot)com>     2009-05-06 08:33:42 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>      2009-05-06 08:40:46 from Richard Huxton <dev(at)archonet(dot)com>       2009-05-06 08:49:32 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>        2009-05-06 09:02:29 from Richard Huxton <dev(at)archonet(dot)com>        2009-05-06 11:57:32 from "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>         2009-05-06 12:49:23 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>          2009-05-06 13:05:10 from Kenneth Marshall <ktm(at)rice(dot)edu>      2009-05-06 14:04:33 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>       2009-05-06 14:26:32 from Kenneth Marshall <ktm(at)rice(dot)edu>        2009-05-06 14:28:46 from Matthew Wakeling <matthew(at)flymine(dot)org>       2009-05-06 14:31:35 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>   2009-05-06 12:58:55 from Kenneth Marshall <ktm(at)rice(dot)edu>  2009-05-06 08:20:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>   2009-05-06 08:31:03 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>    2009-05-06 21:23:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>     2009-05-07 08:20:46 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>      2009-05-07 11:34:55 from Merlin Moncure <mmoncure(at)gmail(dot)com>       2009-05-07 18:36:56 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>        2009-05-07 19:32:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>         2009-05-11 15:18:31 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>          2009-05-11 15:23:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2009-05-11 16:22:39 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>           2009-05-11 19:03:28 from Simon Riggs <simon(at)2ndQuadrant(dot)com>          2009-05-11 17:46:47 from Merlin Moncure <mmoncure(at)gmail(dot)com>          2009-05-11 18:26:54 from Simon Riggs <simon(at)2ndQuadrant(dot)com>           2009-05-11 22:30:43 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>          2009-05-11 19:46:15 from Aidan Van Dyk <aidan(at)highrise(dot)ca>           2009-05-11 22:46:53 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>            2009-05-11 22:54:29 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>             2009-05-12 07:29:08 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>              2009-05-12 08:44:09 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>               2009-05-12 10:19:05 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                2009-05-12 10:48:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2009-05-12 11:16:08 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                  2009-05-12 11:33:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                2009-05-12 11:35:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>                 2009-05-12 12:28:50 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                  2009-05-14 17:03:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                   2009-05-14 18:25:39 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                    2009-05-18 15:07:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                     2009-05-18 18:00:59 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                      2009-05-18 19:27:34 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                       2009-05-18 19:44:34 from "Dave Dutcher" <dave(at)tridecap(dot)com>                        2009-05-18 22:32:43 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                         2009-05-19 13:05:01 from Merlin Moncure <mmoncure(at)gmail(dot)com>                          2009-05-19 15:53:51 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                           2009-05-19 17:38:06 from Merlin Moncure <mmoncure(at)gmail(dot)com>                            2009-05-19 19:15:13 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                             2009-05-19 21:48:49 from Merlin Moncure <mmoncure(at)gmail(dot)com>                       2009-05-18 22:33:07 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                        2009-05-19 07:25:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                         2009-05-19 10:51:56 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                          2009-05-19 12:00:41 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                           2009-05-19 13:35:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                            2009-05-19 14:51:55 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                       2009-05-18 23:00:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2009-05-19 10:24:58 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                        2009-05-19 10:57:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                         2009-05-19 11:17:47 from Matthew Wakeling <matthew(at)flymine(dot)org>                          2009-05-19 11:36:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                           2009-05-19 11:41:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                           2009-05-19 12:01:43 from Matthew Wakeling <matthew(at)flymine(dot)org>                            2009-05-19 13:19:52 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                            2009-05-19 16:38:27 from Scott Carey <scott(at)richrelevance(dot)com>                           2009-05-19 14:00:36 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2009-05-19 12:58:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2009-05-19 13:10:29 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                           2009-05-19 22:49:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2009-05-20 03:54:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2009-05-20 08:11:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                              2009-05-20 11:17:26 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2009-05-20 11:52:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                      2009-05-18 19:37:48 from Scott Carey <scott(at)richrelevance(dot)com>                       2009-05-18 22:32:54 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                        2009-05-19 00:51:19 from Scott Carey <scott(at)richrelevance(dot)com>                         2009-05-19 10:46:45 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                          2009-05-19 17:13:25 from Scott Carey <scott(at)richrelevance(dot)com>                           2009-05-19 18:52:53 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                2009-05-12 11:49:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2009-05-12 12:59:02 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                  2009-05-12 14:21:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2009-05-12 15:22:31 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                    2009-05-12 15:46:37 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                    2009-05-12 16:07:59 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                     2009-05-12 16:16:59 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                    2009-05-12 16:26:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2009-05-12 17:00:26 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                      2009-05-12 17:57:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2009-05-13 10:02:51 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                2009-05-12 12:36:22 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>                 2009-05-12 13:25:38 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                  2009-05-12 14:34:30 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>                   2009-05-12 15:00:00 from Matthew Wakeling <matthew(at)flymine(dot)org>                    2009-05-12 15:04:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                     2009-05-12 15:05:37 from Matthew Wakeling <matthew(at)flymine(dot)org>                      2009-05-12 15:14:31 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>                      2009-05-12 15:18:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2009-05-12 16:32:05 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2009-05-12 16:49:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2009-05-12 19:15:52 from Greg Stark <stark(at)enterprisedb(dot)com>                         2009-05-12 19:52:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2009-05-12 20:24:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                           2009-05-12 20:37:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2009-05-12 21:52:13 from Glenn Maynard <glennfmaynard(at)gmail(dot)com>                            2009-05-13 10:29:25 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                            2009-05-13 14:32:23 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                             2009-05-13 16:16:31 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                              2009-05-13 17:06:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                           2009-05-12 22:41:00 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                            2009-05-13 00:34:48 from Aidan Van Dyk <aidan(at)highrise(dot)ca>                             2009-05-13 00:39:45 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                             2009-05-13 01:41:15 from Stephen Frost <sfrost(at)snowman(dot)net>                        2009-05-12 21:21:52 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>                         2009-05-12 23:54:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>                   2009-05-12 15:37:45 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>            2009-05-12 05:11:40 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>             2009-05-12 07:36:31 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>            2009-05-12 07:43:13 from Andres Freund <andres(at)anarazel(dot)de>             2009-05-12 17:53:24 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>              2009-05-12 18:30:04 from Scott Carey <scott(at)richrelevance(dot)com>               2009-05-12 18:46:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>               2009-05-13 10:22:06 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com> 📎                2009-05-13 16:42:42 from Scott Carey <scott(at)richrelevance(dot)com>                 2009-05-13 21:23:15 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>                  2009-05-14 18:28:23 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>                  2009-05-18 15:10:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2009-05-14 18:34:48 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>     2009-05-07 11:58:50 from Gregory Stark <stark(at)enterprisedb(dot)com>      2009-05-07 12:21:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>   2009-05-06 09:35:50 from Matthew Wakeling <matthew(at)flymine(dot)org>  2009-05-06 11:46:05 from Merlin Moncure <mmoncure(at)gmail(dot)com>   2009-05-06 11:47:22 from Merlin Moncure <mmoncure(at)gmail(dot)com>    2009-05-06 12:33:13 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>     2009-05-06 12:53:45 from Richard Huxton <dev(at)archonet(dot)com>      2009-05-06 13:08:01 from Ries van Twisk <pg(at)rvt(dot)dds(dot)nl>       2009-05-06 14:03:42 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>  2009-05-06 14:34:46 from Kenneth Marshall <ktm(at)rice(dot)edu>   2009-05-06 14:48:21 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>    2009-05-06 15:49:18 from Kenneth Marshall <ktm(at)rice(dot)edu>    2009-05-07 08:41:26 from Dimitri <dimitrik(dot)fr(at)gmail(dot)com>     2009-05-07 15:26:32 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Lists:	pgsql-performance

In response to

• Re: Any better plan for this query?.. at 2009-05-06 11:46:05 from Merlin Moncure

Responses

• Re: Any better plan for this query?.. at 2009-05-06 12:33:13 from Dimitri

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Albe Laurenz	2009-05-06 11:57:32	Re: Any better plan for this query?..
Previous Message	Merlin Moncure	2009-05-06 11:46:05	Re: Any better plan for this query?..