Vacuum strategies - Mailing list pgsql-admin

From Michael Mattox
Subject Vacuum strategies
Date
Msg-id CJEBLDCHAADCLAGIGCOOKEDNCIAA.michael.mattox@verideon.com
Whole thread Raw
Responses Re: Vacuum strategies  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
When I run vacuum (I usually do "vacuum full verbose analyze"), I get a
message saying vacuum should only be performed when no one is using the
database.  My database is used for a website which is active 24 hours a day,
so I'm curious what kind of vacuum strategy I should use?  Should I shut
down the website to vacuum or should I just schedule the vacuum to run in
the middle of the night?  So far I've been doing it while the website is
running without any problems.

Thanks,
Michael Mattox




pgsql-admin by date:

Previous
From: "rakesh"
Date:
Subject: Identifying databases.
Next
From: Markus Bertheau
Date:
Subject: lower not working