DEBUG strings

Поиск
Список
Период
Сортировка
От Ferruccio Zamuner
Тема DEBUG strings
Дата
Msg-id 3A7A8C52.56A198AA@diff.org
обсуждение исходный текст
Ответы Re: DEBUG strings  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I've installed a 7.0.3 PostgreSQL version on a new computer (B):
    I've already compiled and installed PostgreSQL on my old computer
(A),
    so I've mounted the directory from (A) to (B) and I've run "gmake
install"
    from (B).
    I've assigned $PGPATH and $PGLIB, ldconfig has added the $PGLIB
libraries,
    and I've initdb successfully.
    I've created my users and some db.
    Then I've restored some db dumps from (A) to (B) without any
problem,
but "vacuum" from any db gives me following output:

DEBUG:  --Relation pg_type--
DEBUG:  Pages 3: Changed 2, reaped 1, Empty 0, New 0; Tup 155: Vac 2,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 105, MaxLen 109; Re-using:
Free/Avail. Space 6900/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u
sec.
DEBUG:  Index pg_type_typname_index: Pages 2; Tuples 155: Deleted 2. CPU
0.00s/0.00u sec.
DEBUG:  Index pg_type_oid_index: Pages 2; Tuples 155: Deleted 2. CPU
0.00s/0.00u sec.
DEBUG:  --Relation pg_attribute--
DEBUG:  Pages 12: Changed 6, reaped 5, Empty 0, New 0; Tup 866: Vac 46,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 98, MaxLen 98; Re-using:
Free/Avail. Space 7456/4188; EndEmpty/Avail. Pages 0/4. CPU 0.00s/0.00u
sec.
DEBUG:  Index pg_attribute_relid_attnum_index: Pages 6; Tuples 866:
Deleted 46. CPU 0.00s/0.01u sec.
DEBUG:  Index pg_attribute_relid_attnam_index: Pages 12; Tuples 866:
Deleted 46. CPU 0.00s/0.01u sec.
DEBUG:  Rel pg_attribute: Pages: 12 --> 12; Tuple(s) moved: 39. CPU
0.00s/0.02u sec.
DEBUG:  Index pg_attribute_relid_attnum_index: Pages 6; Tuples 866:
Deleted 39. CPU 0.00s/0.01u sec.
DEBUG:  Index pg_attribute_relid_attnam_index: Pages 12; Tuples 866:
Deleted 39. CPU 0.00s/0.01u sec.
DEBUG:  --Relation pg_proc--
DEBUG:  Pages 26: Changed 0, reaped 0, Empty 0, New 0; Tup 1083: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 177, MaxLen 229; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_proc_proname_narg_type_index: Pages 24; Tuples 1083.
CPU 0.01s/0.00u sec.
DEBUG:  Index pg_proc_oid_index: Pages 6; Tuples 1083. CPU 0.00s/0.01u
sec.
DEBUG:  --Relation pg_class--
DEBUG:  Pages 4: Changed 0, reaped 3, Empty 0, New 0; Tup 111: Vac 111,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 106, MaxLen 136; Re-using:
Free/Avail. Space 19356/11764; EndEmpty/Avail. Pages 0/2. CPU
0.00s/0.00u sec.
DEBUG:  Index pg_class_relname_index: Pages 4; Tuples 111: Deleted 111.
CPU 0.00s/0.00u sec.
DEBUG:  Index pg_class_oid_index: Pages 2; Tuples 111: Deleted 111. CPU
0.00s/0.01u sec.
[...]

I would like to know if I've done something wrong, or how I can
understand this event.


Thank you in advance,                                    \fer


В списке pgsql-general по дате отправления:

Предыдущее
От: Florian Steffen
Дата:
Сообщение: Timestamp accuracy
Следующее
От: robert.gravsjo@nsgroup.net ()
Дата:
Сообщение: Re: postgres limitation