Justin Funk <funkju@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general