Re: [HACKERS] v6.5.2 vacuum...?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] v6.5.2 vacuum...?
Date: 1999-09-18 23:38:33
Message-ID: 24670.937697913@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker <scrappy(at)hub(dot)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, MaxLen 109; 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, MaxLen 97; 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1999-09-19 00:00:54 Re: [HACKERS] v6.5.2 vacuum...?
Previous Message Tom Lane 1999-09-18 23:31:27 Re: [HACKERS] case bug?