Re: Should I be concerned ?

2002-07-06 Thread Lukas Ertl 

On Sat, 6 Jul 2002, Patrick Thomas wrote:

 I saw this show up all over my ssh session into a server today:


 NOTICE:  --Relation pg_toast_16386--
 NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
 Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space

[ ... ]

Obviously, you have a PostgreSQL database running, and someone is
VACUUMing the database.

regards,
le

-- 
Lukas Ertl eMail: [EMAIL PROTECTED]
UNIX-Systemadministrator   Tel.:  (+43 1) 4277-14073
Zentraler Informatikdienst (ZID)   Fax.:  (+43 1) 4277-9140
der Universität Wien   http://mailbox.univie.ac.at/~le/


To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-hackers in the body of the message

Should I be concerned ?

2002-07-06 Thread Patrick Thomas 


I saw this show up all over my ssh session into a server today:


NOTICE:  --Relation pg_toast_16386--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space
0/0; EndEmpty/Avail. Pages 0/0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_16386_idx: Pages 1; Tuples 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Analyzing pg_relcheck
NOTICE:  --Relation pg_rewrite--
NOTICE:  Pages 4: Changed 0, reaped 0, Empty 0, New 0; Tup 23: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 104, MaxLen 1456; Re-using: Free/Avail.
Space 8496/8496; EndEmpty/Avail. Pages 0/4.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_rewrite_oid_index: Pages 2; Tuples 23.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_rewrite_rulename_index: Pages 2; Tuples 23.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel pg_rewrite: Pages: 4 -- 4; Tuple(s) moved: 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_16410--
NOTICE:  Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 5: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 163, MaxLen 2034; Re-using: Free/Avail.
Space 8088/8088; EndEmpty/Avail. Pages 0/2.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_16410_idx: Pages 2; Tuples 5.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel pg_toast_16410: Pages: 2 -- 2; Tuple(s) moved: 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Analyzing pg_rewrite
NOTICE:  --Relation pg_statistic--
NOTICE:  Pages 6: Changed 6, reaped 3, Empty 0, New 0; Tup 98: Vac 98,
Keep/VTL 0/0, UnUsed 8, MinLen 80, MaxLen 668; Re-using: Free/Avail. Space
26560/26484; EndEmpty/Avail. Pages 0/4.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_statistic_relid_att_index: Pages 2; Tuples 98: Deleted
98.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel pg_statistic: Pages: 6 -- 3; Tuple(s) moved: 90.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_statistic_relid_att_index: Pages 2; Tuples 98: Deleted
90.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_16408--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space
0/0; EndEmpty/Avail. Pages 0/0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_16408_idx: Pages 1; Tuples 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG:  recycled transaction log file 00B6



Any ideas as to what this means and what I should do (if anything) about
it ?

thanks,

pat


To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-hackers in the body of the message