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. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "If it wasn't for my companion, I believe I'd be having the time of my life" (John Dunbar) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
