| From: | Leif Biberg Kristensen <leif(at)solumslekt(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, mailing(dot)lists(at)octgsoftware(dot)com |
| Subject: | Re: Full Vacuum/Reindex vs autovacuum |
| Date: | 2010-11-08 19:39:51 |
| Message-ID: | 201011082039.51599.leif@solumslekt.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday 8. November 2010 20.06.13 Jason Long wrote:
> I currently have Postgres 9.0 install after an upgrade. My database is
> relatively small, but complex. The dump is about 90MB.
>
> Every night when there is no activity I do a full vacuum, a reindex, and
> then dump a nightly backup.
>
> Is this optimal with regards to performance? autovacuum is set to the
> default.
I've got a database about the same size order (65 MB on disk, 5 MB dump.tgz)
and I never bother with neither full vacuum nor reindexing. I run the default
autovacuum, and if the db becomes bloated for some reason, I just do a
dump/drop/reload cycle. It's done in a few seconds.
regards,
Leif B. Kristensen
http://solumslekt.org/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2010-11-08 19:52:15 | finding the other statement causing a sharelock |
| Previous Message | Pavel Stehule | 2010-11-08 19:34:54 | Re: ERROR: Out of memory - when connecting to database |