Thread: Vacuum analyze decreases speed

Vacuum analyze decreases speed

From
"David M. Richter"
Date:
Hello!

We have postgresql 6.5.3
There is running a big database, the biggest table takes 1 Gigabayte
place.
We used vacuum every night, but without analyze.

So we decided, according of the suggestions of all the books , to make a
vacuum analyze.
Now, the speed is down. Not usable!
We recreated all the index. Nothing better!

We cannot update to 7.1x at a short time (means now, but is planed)
because this is a medical radiology database in heavy use. Maybe at a
later time.

What is vacuum analyze exactly doing?

Where ist the statistic made by analyze stored? So I could just delete
it and make a normal vacuum without analyze to get the old state of the
database?

How can I redo that analyze to get the old state of the database?

I cannot give You an exact query. it doesnt matter, all queries are
slower than before.
#

Did you have experienced the same?
Any suggestions?

Thanks in advance

David
Attachment

Re: Vacuum analyze decreases speed

From
Tom Lane
Date:
"DELETE FROM pg_statistic" should get you back where you were before
VACUUM ANALYZE.
        regards, tom lane