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? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general