Postgres Pro
Downloads
Home   >   mailing lists

Re: DB become enormous with continuos insert and update - Mailing list pgsql-general

From Hfe80
Subject Re: DB become enormous with continuos insert and update
Date
Msg-id 1288131740285-3237903.post@n5.nabble.com
Whole thread Raw
In response to Re: DB become enormous with continuos insert and update  (John R Pierce <pierce@hogranch.com>)
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: DB become enormous with continuos insert and update
Next
From: Alban Hertroys
Date:
Subject: Re: DB become enormous with continuos insert and update