| From: | Hfe80 <federico(dot)mo(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | DB become enormous with continuos insert and update |
| Date: | 2010-10-26 21:01:59 |
| Message-ID: | 1288126919494-3237814.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2010-10-26 21:38:47 | Re: DB become enormous with continuos insert and update |
| Previous Message | Dmitriy Igrishin | 2010-10-26 20:49:10 | Re: Advice needed on application/database authentication/authorization/auditing model |