VACUUM questions - Mailing list pgsql-novice

From Dmitri Touretsky
Subject VACUUM questions
Date
Msg-id 1177691307.20020211211955@listsoft.ru
Whole thread Raw
List pgsql-novice
Good time of the day!

Is there any documentation on how VACUUM works? What I mean, is that
for instance, running vacuum is much faster if I drop indices before
running it and re-create when vacuum is done. But is there a reason to do
that or it's better to run vacuum analyze without dropping indices?

Another question is about pg_toast relation. What is that? I see it if
I run vacuum analyze, but I can't understand if it's good or bad :))
May be you can point me to a place where I can get more detailed
description of vacuum output?...

Also, running VACUUM ANALYZE for one of the tables I got an error
"cannot compare address families 141 and 2"
What can it be?

Best regards,
 Dmitri ( mailto:dmitri@listsoft.ru )

New SOFT daily:  http://www.listsoft.com/



pgsql-novice by date:

Previous
From: Dmitri Touretsky
Date:
Subject: Table with no primary key
Next
From: Pam Wampler
Date:
Subject: "Hot Backups"