Re: Compound Indexes

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: "Chris Browne" <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Compound Indexes
Date: 2007-08-15 14:04:58
Message-ID: e373d31e0708150704q556a09dfn1eb800bd65ff8c60@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> you do a lot of queries like that and the id,s_id restriction isn't very
> selective you might look into tsearch2 which can index that type of query.
>

Thanks. Does tsearch2 come installed with 8.2.3? I am not techie
enough to do all the compiling stuff so I'm hoping it does! How can I
check?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Zolotukhin 2007-08-15 14:09:08 Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
Previous Message Lew 2007-08-15 13:53:51 Re: Writing most code in Stored Procedures