Postgres Pro
Downloads
Home   >   mailing lists

slow seqscan after vacuum analize - Mailing list pgsql-admin

From Edoardo Ceccarelli
Subject slow seqscan after vacuum analize
Date
Msg-id 2scq27$k57u9@mailr-2.tiscali.it
Whole thread Raw
Responses Re: slow seqscan after vacuum analize  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Brian McGuinty
Date:
Subject: unsubscribe
Next
From: eddy@axa.it (Edoardo)
Date:
Subject: slow seqscan after vacuum analize