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)