From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] v6.5.2 vacuum...? |
Date: | 1999-09-19 00:00:54 |
Message-ID: | Pine.BSF.4.10.9909182100370.27097-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Odd...I must have typ'd something wrong the last time, cause now it works
for me too *sigh*
On Sat, 18 Sep 1999, Tom Lane wrote:
> 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
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-09-19 02:07:19 | Re: [HACKERS] v6.5.2 vacuum...? |
Previous Message | Tom Lane | 1999-09-18 23:38:33 | Re: [HACKERS] v6.5.2 vacuum...? |