Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioned tabled not using indexes for full text search - Mailing list pgsql-general

From Tom Lane
Subject Re: Partitioned tabled not using indexes for full text search
Date
Msg-id 26808.1238175959@sss.pgh.pa.us
Whole thread Raw
In response to Partitioned tabled not using indexes for full text search  (Justin Funk <funkju@iastate.edu>)
List pgsql-general
Tree view 
Justin Funk <funkju@iastate.edu> writes:
> Any idea why it would not be using the indexes?

The child table you showed us has a btree index on message_index_col,
which is useless for @@ queries.  Maybe you forgot to specify the
index type while rearranging the table into partitioned form?

            regards, tom lane

pgsql-general by date:

Previous
From: "Dara Olson"
Date:
Subject: metadata development
Next
From: MDB
Date:
Subject: Re: Postgresql On Windows