DB become enormous with continuos insert and update

Поиск
Список
Период
Сортировка
От Hfe80
Тема DB become enormous with continuos insert and update
Дата
Msg-id 1288126919494-3237814.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: DB become enormous with continuos insert and update  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: DB become enormous with continuos insert and update  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
Re: DB become enormous with continuos insert and update  (John R Pierce <pierce@hogranch.com>)
Re: DB become enormous with continuos insert and update  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Some one know how to solve the problem of db that became huge from 700 Mbyte
to 16 Gbyte in 10 days and grow...
Vacuum doesn't solve the problem.
Only vacuum full is too invasive, the only way to reduce the DB  is dump and
restore, but we cannot stop service...

I know that a in a similar db where there is a lot of update the problem was
solved but I don't know how...
Some one Know this problem?

Thank's :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/DB-become-enormous-with-continuos-insert-and-update-tp3237814p3237814.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: Diego Schulz
Дата:
Сообщение: Re: Why Select Count(*) from table - took over 20 minutes?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: DB become enormous with continuos insert and update