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 |
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 |