Skip site navigation (1) Skip section navigation (2)

Re: Arg! PG not using index on an analyzed table

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Reece Hart <reece(at)harts(dot)net>,SF PostgreSQL <sfpug(at)postgresql(dot)org>
Subject: Re: Arg! PG not using index on an analyzed table
Date: 2005-02-02 19:15:53
Message-ID: 200502021115.53397.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Stephen,

> You may also be able to get away with another index on the column using
> text_pattern_ops as the operator class if you need/want other en_US
> features.

Huh.   Can you give me an example?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

sfpug by date

Next:From: Stephan SzaboDate: 2005-02-02 19:55:29
Subject: Re: Arg! PG not using index on an analyzed table
Previous:From: Stephan SzaboDate: 2005-02-02 19:10:59
Subject: Re: Arg! PG not using index on an analyzed table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group