Re: slow IN() clause for many cases

From:	Josh Berkus <josh(at)agliodbs(dot)com>
To:	pgsql-hackers(at)postgresql(dot)org
Cc:	"Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
Subject:	Re: slow IN() clause for many cases
Date:	2005-10-11 19:01:22
Message-ID:	200510111201.22587.josh@agliodbs.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2005-10-10 20:14:58 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2005-10-11 09:58:58 from Simon Riggs <simon(at)2ndquadrant(dot)com>   2005-10-11 10:23:02 from "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>    2005-10-11 15:02:32 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>     2005-10-11 18:13:01 from "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>      2005-10-11 19:01:22 from Josh Berkus <josh(at)agliodbs(dot)com>       2005-10-12 05:06:11 from "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>        2005-10-12 05:22:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2005-10-12 06:26:19 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>    2005-10-12 09:40:45 from Andrew - Supernews <andrew+nonews(at)supernews(dot)com>     2005-10-12 11:52:24 from "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>      2005-10-12 19:29:27 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>     2005-10-12 14:51:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2005-10-12 21:17:51 from Andrew - Supernews <andrew+nonews(at)supernews(dot)com>       2005-10-14 07:40:12 from Andrew - Supernews <andrew+nonews(at)supernews(dot)com>        2005-10-14 22:55:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2005-10-14 23:09:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2005-10-15 00:21:04 from David Fetter <david(at)fetter(dot)org>          2005-10-15 11:59:17 from mark(at)mark(dot)mielke(dot)cc           2005-10-15 15:31:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2005-10-17 11:49:23 from Simon Riggs <simon(at)2ndquadrant(dot)com>           2005-11-29 22:07:06 from Simon Riggs <simon(at)2ndquadrant(dot)com>            2005-11-29 22:21:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2005-11-29 22:39:12 from Joe Conway <mail(at)joeconway(dot)com>             2005-11-29 22:53:38 from Simon Riggs <simon(at)2ndquadrant(dot)com>              2005-11-30 06:18:41 from Martijn van Oosterhout <kleptog(at)svana(dot)org>               2005-11-30 07:05:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2005-12-02 08:18:44 from Simon Riggs <simon(at)2ndquadrant(dot)com>                2005-12-02 09:48:16 from Martijn van Oosterhout <kleptog(at)svana(dot)org>              2005-11-30 06:23:11 from Greg Stark <gsstark(at)mit(dot)edu>         2005-10-15 21:37:53 from Greg Stark <gsstark(at)mit(dot)edu>          2005-10-15 21:42:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2005-10-15 22:27:36 from Greg Stark <gsstark(at)mit(dot)edu>            2005-10-15 22:45:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2005-10-16 16:03:33 from Greg Stark <gsstark(at)mit(dot)edu>              2005-10-16 16:33:29 from Martijn van Oosterhout <kleptog(at)svana(dot)org>               2005-10-16 16:57:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2005-10-16 21:09:57 from Greg Stark <gsstark(at)mit(dot)edu>                 2005-10-16 21:40:48 from Martijn van Oosterhout <kleptog(at)svana(dot)org>                  2005-10-16 21:49:50 from Greg Stark <gsstark(at)mit(dot)edu>                   2005-10-17 04:34:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2005-10-16 16:43:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2005-10-17 19:55:03 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>    2005-10-17 20:30:24 from Simon Riggs <simon(at)2ndquadrant(dot)com>     2005-10-26 21:06:35 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Lists:	pgsql-hackers

In response to

• Re: slow IN() clause for many cases at 2005-10-11 18:13:01 from Ilia Kantor

Responses

• Re: slow IN() clause for many cases at 2005-10-12 05:06:11 from Ilia Kantor

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Kevin Grittner	2005-10-11 19:09:40	database vacuum from cron hanging
Previous Message	Tom Lane	2005-10-11 18:28:02	Re: Spinlocks and CPU Architectures