Alvaro Herrera wrote:
Kamil Srot wrote:
Martijn van Oosterhout wrote:
On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
postgres $db for each database...
Hope it's correct?
Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
you check it was actually completing (no errors)?
Yes, it completes w/o errors... just VACUUM as output...
OK, I'll drop the full part and do it less often...
What user is doing it? Is it a superuser? If it's not, then there's
your problem.
It's user postgres... the vacuum completes correctly...
Thank you,
--
Kamil
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
