Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE Query performance - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: LIKE Query performance
Date
Msg-id 20090128094319.GD26504@a-kretschmer.de
Whole thread Raw
In response to LIKE Query performance  ("Hari, Balaji" <Balaji_Hari@bmc.com>)
List pgsql-performance
Tree view 
In response to Hari, Balaji :
> Hi,
>
>
>
> I am relatively new to PostgreSQL(8.1) and facing the following problem.

Sure? 8.1? Your explain looks like 8.2 or 8.3. 8.3 contains a
full-text-search.

If really not 8.3 you can use tsearch2, it is a contrib-module.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-performance by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Re: LIKE Query performance
Next
From: Phoenix Kiula
Date:
Subject: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)