Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> I created an index on firsttimei, vacuum full analysed, and explain showed me
> *exactly* the same thing(!) The difference being that the query is now
> lightning fast :-)
Perhaps the vacuum got rid of a whole bunch of dead rows?
regards, tom lane