slow seqscan after vacuum analize

From: "Edoardo Ceccarelli" <eddy(at)axa(dot)it>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: slow seqscan after vacuum analize
Date: 2004-02-04 21:23:42
Message-ID: 2scq27$k57u9@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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edoardo 2004-02-04 21:24:20 slow seqscan after vacuum analize
Previous Message Edoardo Ceccarelli 2004-02-04 20:35:57 slow seqscan after vacuum analize