is it possible to get the optimizer to use indexes with a like clause

From:	Dave Cramer <pg(at)fastcrypt(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	is it possible to get the optimizer to use indexes with a like clause
Date:	2003-12-18 23:18:48
Message-ID:	1071789528.1629.10.camel@localhost.localdomain
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2003-12-18 18:44:49 from "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>  2003-12-18 19:17:43 from Christopher Browne <cbbrowne(at)libertyrms(dot)info>   2003-12-18 23:18:48 from Dave Cramer <pg(at)fastcrypt(dot)com>    2003-12-19 01:38:50 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>     2003-12-19 01:38:13 from Doug McNaught <doug(at)mcnaught(dot)org>      2003-12-24 13:58:34 from Dave Cramer <pg(at)fastcrypt(dot)com>     2003-12-19 03:08:37 from Dave Cramer <pg(at)fastcrypt(dot)com>      2003-12-19 03:36:02 from Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>      2003-12-19 03:44:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2003-12-19 09:50:12 from Dave Cramer <pg(at)fastcrypt(dot)com>        2003-12-19 14:38:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2003-12-19 16:00:25 from Erki Kaldjärv <erki(at)webware(dot)ee>    2003-12-19 03:22:38 from Christopher Browne <cbbrowne(at)acm(dot)org>  2003-12-18 19:56:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2003-12-19 13:53:22 from "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>    2003-12-19 15:07:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2003-12-19 17:44:17 from William Yu <wyu(at)talisys(dot)com>
Lists:	pgsql-performance

In response to

• Re: why do optimizer parameters have to be set manually? at 2003-12-18 19:17:43 from Christopher Browne

Responses

• Re: is it possible to get the optimizer to use indexes at 2003-12-19 01:38:50 from Christopher Kings-Lynne
• Re: is it possible to get the optimizer to use indexes with a like clause at 2003-12-19 03:22:38 from Christopher Browne

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Doug McNaught	2003-12-19 01:38:13	Re: is it possible to get the optimizer to use indexes
Previous Message	Tom Lane	2003-12-18 19:56:20	Re: why do optimizer parameters have to be set manually?