Re: index not used again

On Sun, 2 Apr 2006, Jan Kesten wrote:

> Stephan Szabo schrieb:
>
> > Did you reset the table contents between these two (remember that
> > explain analyze actually runs the query)? The second appears to be
> > changing no rows from the output.
>
> I for myself did not, but as there are runnig automatic jobs
> periodically I can't tell, if one ran in the time while I was testing
> (but I guess not). At starting my tests all rows contained a zero for
> all tokens and there should be no ones at all.

The reason I asked is that the explain analyze output for the first query
on fak6 (using a seqscan) seemed to imply 24k rows actually matched the
condition and were updated, so comparisons to the later times may be
skewed.