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

Reply via email to