Re: slow seqscan after vacuum analize - Mailing list pgsql-admin

On Wed, 4 Feb 2004, Edoardo Ceccarelli wrote:

> I have a simple query that scans each record, like this: select * from utente where
> luogorilasciodoc='ciao'
> The execution time BEFORE vacuum is: 1203ms The execution time AFTER vacuum is: 6656ms
> !!!
> What is going on? Thought that one vaccum the db to get better performance!
>
> PostgreSQL Ver. 7.3.4 on linux

Can you show us the output of "explain analyze select * from ..." for both
before and after a vacuum?   i.e. with the difference in performance.  If
not, just an explain analyze of the way it runs now might be enough.