Re: DB become enormous with continuos insert and update

Поиск
Список
Период
Сортировка
От Hfe80
Тема Re: DB become enormous with continuos insert and update
Дата
Msg-id 1288131740285-3237903.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: DB become enormous with continuos insert and update  (John R Pierce <pierce@hogranch.com>)
Ответы Re: DB become enormous with continuos insert and update  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: DB become enormous with continuos insert and update  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
Список pgsql-general
Дерево обсуждения 
We tried everything...vacumm works.
The problem is that updates need more space becouse datas is not overwritten
in the same space...
it seems that when there is huge update db grow to create space necessary
...700 Mb every time and than vacuum works but only since next update! and
db grow 700Mb more and 700 Mb more....

It seems a bug

Sorry for my english that isn't so good :(
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/DB-become-enormous-with-continuos-insert-and-update-tp3237814p3237903.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: DB become enormous with continuos insert and update
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: DB become enormous with continuos insert and update