A small warning with running VACUUM too often. Any predefined
statements will fail if they are defined before the VACUUM and used
afterwards. I had a daemon which did a VACUUM autonomously. Which
occasionally coincided with a user request, and broke it :)
Jay Sprenkle wrote:
On 9/13/05, Ray Mosley <[EMAIL PROTECTED]> wrote:
Is it overkill to VACUUM every time the last user terminates?
It depends.
If your program is very active rearranging database records every time it
runs probably not.
--
Ben Clewett
+44(0)1923 460000
Project Manager
Road Tech Computer Systems Ltd
http://www.roadrunner.uk.com
