VACUUM process running for a long time

Поиск
Список
Период
Сортировка
От Jan Krcmar
Тема VACUUM process running for a long time
Дата
Msg-id p2v27cffc1004140701wf74c0a01y894f621dee1bd3c5@mail.gmail.com
обсуждение исходный текст
Ответы Re: VACUUM process running for a long time  (John R Pierce <pierce@hogranch.com>)
Re: VACUUM process running for a long time  (Adrian von Bidder <avbidder@fortytwo.ch>)
Re: VACUUM process running for a long time  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
hi

i've got the database (about 300G) and it's still growing.

i am inserting new data (about 2G/day) into the database (there is
only one table there) and i'm also deleting about 2G/day (data older
than month).

the documentation says, one should run VACUUM if there are many
changes in the database, but the vacuumdb never finishes sooner than
the new data should be imported.

is there any technique that can solve this problem?

thanks
fous

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [BUGS] Can you please let me know?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: How to insert Ecoded values into postrgresql