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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance