Re: Postgresqlism & Vacuum? - Mailing list pgsql-general

From Steve Wolfe
Subject Re: Postgresqlism & Vacuum?
Date
Msg-id 008301bfa65c$c7f30da0$85755ad1@iboats.com
Whole thread Raw
In response to Re: Postgresqlism & Vacuum?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
> Okay, this *used* to be a problem way way back, but I definitely don't
> vacuum my databases nightly ... most times I don't do it until something
> odd comes up that I figure that I may as well vacuum first to see if it
> makes a differnece ...

  I used to take that approach, and I got tired of running into odd,
inexplicable problems that only a VACUUM ANALYZE would fix, so I ended up
using a cron job to do it nightly.

steve


pgsql-general by date:

Previous
From: Haroldo Stenger
Date:
Subject: Re: Does error within transaction imply restarting it?
Next
From: Andrew Schmeder
Date:
Subject: Re: Parallel databases?