On Fri, Apr 18, 2003 at 10:20:33AM -0400, Tom Lane wrote:
> 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?
I had done a vacuum full earlier.. and by dog slow versus lightning
fast, I mean 1 unit of data inserted in just over an hour versus
8.6 units of data inserted in 2 mins 29 seconds(!) Well, I'm
certainly not complaining!
Cheers,
Patrick