|
su.dbms
- SU.DBMS ----------------------------------------------------------------------
From : Sergei Batakov 2:5020/400 10 Dec 2001 13:57:31
To : All
Subject : PostgreSQL and VACUUM
--------------------------------------------------------------------------------
Привет всем...
народ поскажите почему сабж...
очень медленно делается...
cdr=# VACUUM verbose cdr;
NOTICE: --Relation cdr--
NOTICE: Pages 13738: Changed 0, reaped 5064, Empty 0, New 0; Tup 573679:
Vac 59930, Keep/VTL 0/0, Crash 0, UnUs.
NOTICE: Index cdr_pkey: Pages 9675; Tuples 573679: Deleted 59930. CPU
2.28s/4.85u sec.
NOTICE: Index outgoung_index: Pages 11015; Tuples 573679: Deleted 59930.
CPU 1.03s/1.92u sec.
NOTICE: Index areacod_cdr: Pages 8866; Tuples 573679: Deleted 59930. CPU
0.74s/2.11u sec.
NOTICE: Index incoming_index: Pages 10908; Tuples 573679: Deleted 59930.
CPU 0.85s/1.99u sec.
NOTICE: Index cli_index: Pages 10784; Tuples 573679: Deleted 59930. CPU
1.03s/2.43u sec.
NOTICE: Index ddi_index: Pages 6557; Tuples 573679: Deleted 59930. CPU
1.45s/3.62u sec.
--- ifmail v.2.15dev5
* Origin: Demos online service (2:5020/400)
Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
|
