Re: anti-join chosen even when slower than old plan

From:	Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject:	Re: anti-join chosen even when slower than old plan
Date:	2010-11-10 05:36:59
Message-ID:	AANLkTimqqhfge=v+uzhoMrQGCWXTbx0SEAJGUs2EnNeB@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-11-09 21:18:13 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2010-11-09 23:07:42 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>   2010-11-09 23:17:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2010-11-09 23:24:48 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2010-11-10 00:08:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2010-11-10 05:36:59 from Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>   2010-11-10 15:15:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>    2010-11-10 15:33:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2010-11-10 22:07:52 from Robert Haas <robertmhaas(at)gmail(dot)com>     2010-11-10 22:43:43 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>      2010-11-10 23:07:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2010-11-11 03:47:21 from Robert Haas <robertmhaas(at)gmail(dot)com>        2010-11-11 13:51:22 from Kenneth Marshall <ktm(at)rice(dot)edu>         2010-11-11 14:15:58 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>          2010-11-11 14:28:09 from Kenneth Marshall <ktm(at)rice(dot)edu>          2010-11-11 17:05:56 from Bob Lunney <bob_lunney(at)yahoo(dot)com>      2010-11-11 05:14:18 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>       2010-11-11 15:00:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>        2010-11-11 17:13:08 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>         2010-11-11 17:45:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2010-11-11 18:11:01 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>          2011-01-19 19:47:03 from Bruce Momjian <bruce(at)momjian(dot)us>         2010-11-11 17:55:39 from Craig James <craig_james(at)emolecules(dot)com>        2010-11-11 17:57:54 from Robert Haas <robertmhaas(at)gmail(dot)com>         2010-11-11 18:23:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2010-11-11 18:58:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2010-11-11 19:05:41 from Robert Haas <robertmhaas(at)gmail(dot)com>            2010-11-11 19:35:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2010-11-11 19:47:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>             2010-11-11 20:29:40 from Robert Haas <robertmhaas(at)gmail(dot)com>              2010-11-11 20:56:25 from <gnuoytr(at)rcn(dot)com>               2010-11-11 21:28:19 from Kenneth Marshall <ktm(at)rice(dot)edu>              2010-11-12 09:15:17 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>               2010-11-12 16:30:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                2010-11-12 16:43:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2010-11-12 18:57:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2010-11-13 05:44:25 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>                  2010-11-13 09:32:12 from "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>                   2010-11-13 16:15:06 from bricklen <bricklen(at)gmail(dot)com>                   2010-11-14 00:20:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2011-01-19 20:04:22 from Bruce Momjian <bruce(at)momjian(dot)us>                  2011-01-20 09:17:08 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>                   2011-01-20 14:19:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2011-01-20 16:16:05 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>                    2011-01-27 01:40:50 from Bruce Momjian <bruce(at)momjian(dot)us>              2011-01-19 20:03:19 from Bruce Momjian <bruce(at)momjian(dot)us>               2011-01-20 16:36:05 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>             2010-11-12 09:07:31 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>              2010-11-12 10:10:01 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>               2010-11-12 10:56:34 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>                2010-11-12 12:06:25 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>                 2010-11-12 12:40:52 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>           2010-11-11 19:15:55 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>            2010-11-11 19:22:59 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>            2010-11-11 19:41:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2010-11-11 19:50:28 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>             2010-11-11 19:52:12 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>           2010-11-11 20:11:04 from Andres Freund <andres(at)anarazel(dot)de>          2010-11-11 19:02:14 from Robert Haas <robertmhaas(at)gmail(dot)com>           2010-11-11 19:17:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2010-11-11 08:01:12 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
Lists:	pgsql-performance

In response to

• Re: anti-join chosen even when slower than old plan at 2010-11-10 00:08:00 from Tom Lane

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Mark Kirkwood	2010-11-10 09:10:39	Re: Array interface
Previous Message	bricklen	2010-11-10 00:10:33	Re: Huge overestimation in rows expected results in bad plan