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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

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