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 | ajs@xxxxxxxxxxxxxxx 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
