slow seqscan after vacuum analize

From: "Edoardo Ceccarelli" <eddy(at)expot(dot)it>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: slow seqscan after vacuum analize
Date: 2004-02-04 20:35:57
Message-ID: 2scq27$k4lid@mailr-2.tiscali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Thank you
Edoardo

In response to

  • unsubscribe at 2004-02-04 18:34:02 from Brian McGuinty

Browse pgsql-admin by date

  From Date Subject
Next Message Edoardo Ceccarelli 2004-02-04 21:23:42 slow seqscan after vacuum analize
Previous Message Brian McGuinty 2004-02-04 18:34:02 unsubscribe