big pg_attribute_relid_attnam_index files

Поиск
Список
Период
Сортировка
Искать
От
darthxiong@libero.it
Тема
big pg_attribute_relid_attnam_index files
Дата
Msg-id
20021022094913.5BC52475D39@postgresql.org
Список
Дерево обсуждения
big pg_attribute_relid_attnam_index files darthxiong@libero.it
hi all... i was peeking in the files of postgres ( 7.2.1 ) and found a 700Mb 
file . looking in the system tables, i found that it corresponds to the index 
pg_attribute_relid_attnam_index. Also, pg_attribute_relid_attnum_index file 
is similar. I set up another db usinc rsync, dumped the db, droppped it, and 
restored. now the 2 files look normal. 
I run vacuum --analize about 3 times a day. why that files become so big? 
there is a solution, other than dump & restore ?
TIA 
Ivan
-- 
Lucy:	Dance, dance, dance.  That is all you ever do.
	Can't you be serious for once?
Snoopy: She is right!  I think I had better think
	of the more important things in life!
	(pause)
	Tomorrow!!
В списке pgsql-general по дате отправления
От: Miguel Carvalho
Дата:
От: Patrick Fiche
Дата:
FAQ