| From: | Dmitri Touretsky <dmitri(at)listsoft(dot)ru> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | VACUUM questions |
| Date: | 2002-02-11 18:19:55 |
| Message-ID: | 1177691307.20020211211955@listsoft.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)listsoft(dot)ru )
New SOFT daily: http://www.listsoft.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pam Wampler | 2002-02-11 18:54:29 | "Hot Backups" |
| Previous Message | Dmitri Touretsky | 2002-02-11 18:01:15 | Table with no primary key |