Re: [HACKERS] v6.5.2 vacuum...?
От | Tom Lane |
---|---|
Тема | Re: [HACKERS] v6.5.2 vacuum...? |
Дата | |
Msg-id | 24670.937697913@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] v6.5.2 vacuum...? (The Hermit Hacker <scrappy@hub.org>) |
Ответы |
Re: [HACKERS] v6.5.2 vacuum...?
|
Список | pgsql-hackers |
The Hermit Hacker <scrappy@hub.org> writes: > Also, side note...\h vacuum shows that 'vacuum [verbose] analyze' should > work, but if you try and run it,it gives an error...error in psql's help, > or the backend? ??? Works for me ... in fact that's how I usually run vacuum: play=> vacuum verbose analyze; NOTICE: --Relation pg_type-- NOTICE: Pages 2: Changed 0, Reapped 1, Empty 0, New 0; Tup 114: Vac 1, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 109, MaxLen109; Re-using: Free/Avail. Space 3076/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. NOTICE: Index pg_type_typname_index: Pages 2; Tuples 114: Deleted 1. Elapsed 0/0 sec. NOTICE: Index pg_type_oid_index: Pages 2; Tuples 114: Deleted 1. Elapsed 0/0 sec. NOTICE: --Relation pg_attribute-- NOTICE: Pages 6: Changed 0, Reapped 1, Empty 0, New 0; Tup 422: Vac 7, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 97, MaxLen97; Re-using: Free/Avail. Space 3080/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. NOTICE: Index pg_attribute_attrelid_index: Pages 4; Tuples 422: Deleted 7. Elapsed 0/0 sec. [ etc etc etc ] What error do you get exactly? regards, tom lane
В списке pgsql-hackers по дате отправления: