Vacuum analyze decreases speed

From: "David M(dot) Richter" <d(dot)richter(at)dkfz(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Vacuum analyze decreases speed
Date: 2001-12-07 15:39:51
Message-ID: 3C10E2C7.BA8D361D@dkfz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 Content-Type Size
d.richter.vcf text/x-vcard 498 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-12-07 17:11:46 Re: Vacuum analyze decreases speed
Previous Message Tom Lane 2001-12-07 15:36:13 Re: [SQL] how to change the type