Quick Links

Re: DB become enormous with continuos insert and update

From:	Hfe80 <federico(dot)mo(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: DB become enormous with continuos insert and update
Date:	2010-10-26 22:22:20
Message-ID:	1288131740285-3237903.post@n5.nabble.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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.

In response to

Re: DB become enormous with continuos insert and update at 2010-10-26 21:55:53 from John R Pierce

Responses

Re: DB become enormous with continuos insert and update at 2010-10-26 22:45:57 from Alban Hertroys
Re: DB become enormous with continuos insert and update at 2010-10-27 06:05:47 from Gabriele Bartolini

Browse pgsql-general by date

	From	Date	Subject
Next Message	Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]	2010-10-26 22:44:57	PostgreSQL 32 bit DB on 64 bit machine
Previous Message	Peter Geoghegan	2010-10-26 22:12:09	Re: DB become enormous with continuos insert and update