| From: | Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: database size grows (even after vacuum (full and analyze)).... |
| Date: | 2006-05-03 17:15:37 |
| Message-ID: | 1146676537.2340.80.camel@sandoval |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
On Wed, 2006-05-03 at 15:45, Bruno Wolff III wrote:
> On Wed, May 03, 2006 at 12:02:18 +0100,
> Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt> wrote:
> > certain life time for each record).
> >
> > Dispite this, the file system size still grows (at about 500KB in about
> > 1000 minutes).
>
> How often are you vacuuming the table?
I wrote that on my original e-mail: I do a "VACUUM ANALYZE" every 30
minutes and a "VACUUM FULL" every 2 hours.
Should I do anything else ? Thanks.
tahnks
joao
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas McNaught | 2006-05-03 17:16:52 | Re: out of memory for query result |
| Previous Message | Karen Hill | 2006-05-03 17:02:17 | Re: insert into a view? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2006-05-03 17:29:10 | Re: database size grows (even after vacuum (full and analyze)).... |
| Previous Message | Bruno Wolff III | 2006-05-03 14:45:32 | Re: database size grows (even after vacuum (full and analyze)).... |