| From: | "Anton Melser" <melser(dot)anton(at)gmail(dot)com> |
|---|---|
| To: | "Ross Boylan" <RossBoylan(at)stanfordalumni(dot)org> |
| Cc: | "Joris Dobbelsteen" <joris(at)familiedobbelsteen(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: database 1.2G, pg_dump 73M?! |
| Date: | 2008-04-05 15:43:36 |
| Message-ID: | 92d3a4950804050843n5adcf45bh28d68f5296b9c53c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I am still trying to figure out if the database was getting any
> automatic vacuuming at all. The Postgres documentation (the database is
> 8.2, though I'm moving to 8.3 soon) sounds as if it's on automatically,
> but the Debian-specific documentation suggests I may need to do some
> additional things to enable it.
This is probably far too late but anyway. You do indeed have to enable
autovacuum with 8.2, as it isn't enabled by default, at least with
most distributions. 8.3 it's by default with most distributions.
# show autovacuum;
will tell you if it's on.
Cheers
Anton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2008-04-05 16:22:43 | Re: mac ports question |
| Previous Message | Tom Lane | 2008-04-05 15:21:47 | Re: Conversion to 8.3 |