slow seqscan after vacuum analize

From: eddy(at)axa(dot)it (Edoardo)
To: pgsql-admin(at)postgresql(dot)org
Subject: slow seqscan after vacuum analize
Date: 2004-02-04 21:24:20
Message-ID: 14f102db.0402041324.30033235@posting.google.com
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

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2004-02-04 21:45:01 Re: slow seqscan after vacuum analize
Previous Message Edoardo Ceccarelli 2004-02-04 21:23:42 slow seqscan after vacuum analize