I have a table that is partitioned on a daily basis.
Full text searches used to be respectably fast with large tables (40
million + records) but insert speed would slow down. So I went with a
partitioned approach. But now, it doesn't seem like the indexes are
being used.
Any idea why it would
Justin Funk fun...@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?