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

From: Reece Hart <reece(at)harts(dot)net>
To: SF PostgreSQL <sfpug(at)postgresql(dot)org>
Subject: Re: Arg! PG not using index on an analyzed table
Date: 2005-02-02 20:08:09
Message-ID: 1107374889.10110.19.camel@tallac.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

On Wed, 2005-02-02 at 11:10 -0800, Stephan Szabo wrote:

> 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.

Indeed! Yippee! I was fearing another initdb and restore for several
databases. Of course, I'm chagrined that I now need to go figure out
which indexes need redefinition.

Stephan, do you know what overhead (space or time) this induces, if any?

Thanks!

-Reece

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

In response to

Responses

Browse sfpug by date

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