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

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 (view raw or flat)
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

sfpug by date

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

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