Re: [SQL] Yet Another (Simple) Case of Index not used

From:	"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To:	<jim(at)nasby(dot)net>, "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc:	"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Kevin Brown" <kevin(at)sysexperts(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: [SQL] Yet Another (Simple) Case of Index not used
Date:	2003-04-22 08:33:27
Message-ID:	024001c308a9$d8bd0f70$6500a8c0@fhp.internal
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2003-04-08 19:57:16 from "Denis" <denis(at)next2me(dot)com>  2003-04-08 20:25:44 from Dennis Gearon <gearond(at)cvc(dot)net>  2003-04-08 21:52:40 from Josh Berkus <josh(at)agliodbs(dot)com>   2003-04-09 00:21:16 from "Denis (at) Next2Me" <denis(at)next2me(dot)com>    2003-04-09 01:59:37 from Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>    2003-04-09 02:35:22 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>    2003-04-09 16:18:45 from Josh Berkus <josh(at)agliodbs(dot)com>     2003-04-19 13:01:46 from Kevin Brown <kevin(at)sysexperts(dot)com>      2003-04-19 15:58:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2003-04-19 19:03:18 from Josh Berkus <josh(at)agliodbs(dot)com>        2003-04-19 20:26:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2003-04-22 08:23:39 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>         2003-04-22 08:33:27 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>       2003-04-20 01:13:37 from Kevin Brown <kevin(at)sysexperts(dot)com>        2003-04-20 03:34:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2003-04-20 06:28:52 from Kevin Brown <kevin(at)sysexperts(dot)com>          2003-04-20 10:07:53 from Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>           2003-04-20 15:25:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2003-04-20 15:37:57 from Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>          2003-04-20 15:21:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2003-04-20 16:46:09 from Andrew Sullivan <andrew(at)libertyrms(dot)info>           2003-04-21 00:46:30 from Kevin Brown <kevin(at)sysexperts(dot)com>            2003-04-21 01:53:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2003-04-21 16:14:43 from Josh Berkus <josh(at)agliodbs(dot)com>         2003-04-23 16:32:09 from Greg Stark <gsstark(at)mit(dot)edu>  2003-04-08 23:46:23 from Martijn van Oosterhout <kleptog(at)svana(dot)org>   2003-04-09 00:10:01 from "Denis (at) Next2Me" <denis(at)next2me(dot)com>    2003-04-09 03:18:39 from Martijn van Oosterhout <kleptog(at)svana(dot)org>     2003-04-09 05:54:46 from "Denis (at) Next2Me" <denis(at)next2me(dot)com>   2003-04-09 00:44:48 from Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
Lists:	pgsql-general pgsql-performance pgsql-sql

In response to

• Re: [SQL] Yet Another (Simple) Case of Index not used at 2003-04-22 08:23:39 from Jim C. Nasby

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jeremiah Jahn	2003-04-22 13:13:50	Re: > 16TB worth of data question
Previous Message	Jim C. Nasby	2003-04-22 08:23:39	Re: [SQL] Yet Another (Simple) Case of Index not used

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Kevin Brown	2003-04-22 11:44:30	Re: [PERFORM] Foreign key performance
Previous Message	Jim C. Nasby	2003-04-22 08:30:58	Re: choosing the right platform

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Bharath Seshadri	2003-04-22 10:00:16	RelationForgetRelation error in postgres 7.2.2
Previous Message	Jim C. Nasby	2003-04-22 08:23:39	Re: [SQL] Yet Another (Simple) Case of Index not used