Auto Vacuum question?

Поиск
Список
Период
Сортировка
От Charles.Hou
Тема Auto Vacuum question?
Дата
Msg-id 1180966368.172224.250500@x35g2000prf.googlegroups.com
обсуждение исходный текст
Ответы Re: Auto Vacuum question?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
i set the auto vacuum option to enable. but my database size(hard-
disk
space) still increased from 420MB to 440MB in 8 hours. most of the
operations in this database are the "Select" query command, just few
of "Update or Insert".
why it can be increased so strongly?
after i executed the command " vaccumdb -f -z testdb", but the size
just decreased 1 or 2MB...
what's the problem?
how to know which command(select,insert....) takes the hurge loading
to database in this time?

computer environment:
System: Red Hat Enterprise 4
Postgresql Server: 8.0.13
count of client connected : about 100 pc


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

Предыдущее
От: Andreas
Дата:
Сообщение: Re: Need a wee bit more info on PostgreSQL's SSL security options
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Auto Vacuum question?