Re: Strangely Variable Query Performance

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Steve <cheetah(at)tanabi(dot)org>
Cc:	Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Strangely Variable Query Performance
Date:	2007-04-12 23:32:43
Message-ID:	10117.1176420763@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2007-04-11 22:02:48 from Jason Lustig <lustig(at)brandeis(dot)edu>  2007-04-12 04:34:14 from Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>  2007-04-12 05:33:12 from Jeff Frost <jeff(at)frostconsultingllc(dot)com>   2007-04-12 15:35:24 from Jeff Frost <jeff(at)frostconsultingllc(dot)com>    2007-04-12 21:58:49 from Jason Lustig <lustig(at)brandeis(dot)edu>     2007-04-12 22:18:14 from Guido Neitzer <lists(at)event-s(dot)net>  2007-04-12 13:26:24 from Ron <rjpeace(at)earthlink(dot)net>   2007-04-12 14:08:03 from Guido Neitzer <lists(at)event-s(dot)net>    2007-04-12 14:59:10 from Ron <rjpeace(at)earthlink(dot)net>     2007-04-12 15:19:57 from Guido Neitzer <lists(at)event-s(dot)net>      2007-04-12 16:56:04 from Scott Marlowe <smarlowe(at)g2switchworks(dot)com>       2007-04-12 17:03:15 from Jeff Frost <jeff(at)frostconsultingllc(dot)com>        2007-04-12 19:10:18 from Carlos Moreno <moreno_pg(at)mochima(dot)com>        2007-04-12 21:03:17 from Steve <cheetah(at)tanabi(dot)org>         2007-04-12 21:24:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2007-04-12 21:40:28 from Steve <cheetah(at)tanabi(dot)org>           2007-04-12 22:01:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2007-04-12 22:03:47 from Steve <cheetah(at)tanabi(dot)org>             2007-04-12 22:22:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2007-04-12 22:24:48 from Steve <cheetah(at)tanabi(dot)org>         2007-04-12 21:52:04 from Scott Marlowe <smarlowe(at)g2switchworks(dot)com>          2007-04-12 22:04:33 from Steve <cheetah(at)tanabi(dot)org>           2007-04-12 22:14:37 from Scott Marlowe <smarlowe(at)g2switchworks(dot)com>            2007-04-12 22:41:33 from Steve <cheetah(at)tanabi(dot)org>            2007-04-12 23:00:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2007-04-12 22:56:47 from Steve <cheetah(at)tanabi(dot)org>              2007-04-12 23:29:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2007-04-12 23:28:02 from Steve <cheetah(at)tanabi(dot)org>              2007-04-12 23:32:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2007-04-12 23:40:15 from Steve <cheetah(at)tanabi(dot)org>                2007-04-13 00:00:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2007-04-13 00:05:48 from Steve <cheetah(at)tanabi(dot)org>                  2007-04-13 00:20:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2007-04-13 00:34:18 from Steve <cheetah(at)tanabi(dot)org>                    2007-04-13 02:40:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2007-04-13 03:49:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2007-04-13 03:55:00 from Steve <cheetah(at)tanabi(dot)org>                      2007-04-13 04:38:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2007-04-17 03:24:15 from "Robins Tharakan" <robins(at)pobox(dot)com>                        2007-04-17 03:43:30 from Robins <tharakan(at)gmail(dot)com>                         2007-04-17 04:44:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2007-04-13 22:48:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2007-04-13 23:24:09 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>                        2007-04-14 09:04:24 from "Dann Corbit" <DCorbit(at)connx(dot)com>                         2007-04-14 15:52:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2007-04-14 17:19:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2007-04-14 18:21:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2007-04-14 22:02:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                          2007-04-14 22:55:45 from Steve <cheetah(at)tanabi(dot)org>                           2007-04-15 05:11:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2007-04-15 08:13:53 from Steve <cheetah(at)tanabi(dot)org>                            2007-04-16 22:13:54 from Steve <cheetah(at)tanabi(dot)org>                             2007-04-16 23:01:04 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>                              2007-04-17 19:04:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                               2007-04-17 19:19:25 from Steve <cheetah(at)tanabi(dot)org>                       2007-04-14 08:24:07 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>               2007-04-12 23:42:49 from Steve <cheetah(at)tanabi(dot)org>
Lists:	pgsql-hackers pgsql-patches pgsql-performance

In response to

• Re: Strangely Variable Query Performance at 2007-04-12 22:56:47 from Steve

Responses

• Re: Strangely Variable Query Performance at 2007-04-12 23:40:15 from Steve
• Re: Strangely Variable Query Performance at 2007-04-12 23:42:49 from Steve

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Steve	2007-04-12 23:40:15	Re: Strangely Variable Query Performance
Previous Message	Tom Lane	2007-04-12 23:29:09	Re: Strangely Variable Query Performance

Browse pgsql-patches by date

	From	Date	Subject
Next Message	Steve	2007-04-12 23:40:15	Re: Strangely Variable Query Performance
Previous Message	Tom Lane	2007-04-12 23:29:09	Re: Strangely Variable Query Performance

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Steve	2007-04-12 23:40:15	Re: Strangely Variable Query Performance
Previous Message	Tom Lane	2007-04-12 23:29:09	Re: Strangely Variable Query Performance