Postgres Pro
Downloads
Home   >   mailing lists

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

From Hfe80
Subject DB become enormous with continuos insert and update
Date
Msg-id 1288126919494-3237814.post@n5.nabble.com
Whole thread Raw
Responses Re: DB become enormous with continuos insert and update
Re: DB become enormous with continuos insert and update
Re: DB become enormous with continuos insert and update
Re: DB become enormous with continuos insert and update
List pgsql-general
Tree view 
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 by date:

Previous
From: Diego Schulz
Date:
Subject: Re: Why Select Count(*) from table - took over 20 minutes?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: DB become enormous with continuos insert and update