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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings