Daniel Vogelbacher wrote:

>
> You mean that the first query cleans up the indicies
> and after gc has finished, the query runs faster?

I mean that after deletion and commit, select count(*) garbage collects
not only data pages but also index pages. So existence of indices does
affect this query, while you were suggesting the opposite.


Dmitry