On Mon, Aug 27, 2007 at 10:03:04PM +0200, Kamil Srot wrote:
> >
> Sure, I ment it like I'll do the FULL vacuum less often than daily and
> do daily the plain vacuum command.
If you have your servers set up correctly, you should never need to
perform VACUUM FULL.
> Well, I do list all databases with the command "psql -U postgres -l -t"
> and with some shell coding I do vacuum all shown databases...
> I don't think there is some problem in it...
>
> If you do see some, can you give me a hint?
I don't think I've seen the script itself. Without seeing it, I can
only guess. But you don't actually need to do that. You should be
able to run vacuumdb -a, and get the result you need.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
