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.