Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)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