Andrew Sullivan wrote:
On Mon, Aug 27, 2007 at 07:15:44PM +0200, Kamil Srot wrote:
OK, I'll drop the full part and do it less often...
This doesn't address your problem, but when you move from VACUUM FULL
to VACUUM, you want to do it _more_ often, not less.
Sure, I ment it like I'll do the FULL vacuum less often than daily and
do daily the plain vacuum command.
But given what you've posted, I am not even a little bit convinced
your script is working as you think it is. You're clearly not
managing to vacuum the entire database sometimes.
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?
Thank you,
--
Kamil
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
