Good point seems autovacuum is already turned on, so not necessary.
Although purely out of curiosity I'd still be interested to hear how to
execute this statement if possible or is it not possible from web2py?
On Tuesday, February 18, 2014 11:18:17 AM UTC-5, Richard wrote:
>
> postgresql.conf
>
> autovacuum = on
>
> Except you have particular need should be alright with postgres 9 +
>
> Richard
>
>
> On Mon, Feb 17, 2014 at 8:42 PM, User <sour...@gmail.com <javascript:>>wrote:
>
>> I'm trying to run postgresql vacuum from web2py (ultimately to be run by
>> a scheduled task) and I get the following error:
>>
>> db.executesql('VACUUM sometable;')
>> *** ProgrammingError: ('ERROR', '25001', 'VACUUM cannot run inside a
>> transaction
>> block')
>>
>> How can I run VACUUM from web2py?
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
