Is it possible (to mix two threads) that you had CLUSTERed the table on the old database in a way that retrieved the records in this query faster?
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster