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