Meaning of vacuum output
От | Jeffrey W. Baker |
---|---|
Тема | Meaning of vacuum output |
Дата | |
Msg-id | 1011200683.16838.4.camel@heat обсуждение исходный текст |
Ответы |
Re: Meaning of vacuum output
|
Список | pgsql-general |
I have no idea what the output of vacuum verbose means. rupert=# vacuum verbose resp_header; NOTICE: --Relation resp_header-- NOTICE: Pages 28276: Changed 4, Empty 0; Tup 2437108: Vac 0, Keep 2295773, UnUsed 96275. Total CPU 1.79s/0.38u sec elapsed 2.72 sec. VACUUM rupert=# select count(*) from resp_header; count -------- 141357 (1 row) There's nowhere near 2.437e6 tuples in the table, but the difference between Tup and Keep seems to be the number of tuples in the table. But what does this mean? Are there 2.295e6 deleted tuples hanging around in the table? That doesn't make sense because vacuum is supposed to toss deleted tuples (right?). What's unused? What is Vac and why is it *always* 0? I don't want unused tuples in my tables! Can you understand my confusion? Regards, Jeffrey Baker
В списке pgsql-general по дате отправления: