Thread: Regarding vacuumdb

Regarding vacuumdb

From

komala pelleti

Date:

27 July 2018, 15:41:47

Hi,

We are using postgres 9.5.

Iam not able to call vaccumdb from functions.: function check for tables for databse if pct_dead > 100, then we are issuing a vaccum on that table.

getting error .

is there any otherway to call vaccumdb ?

Thanks N Regards

Komala P

Re: Regarding vacuumdb

From

Andreas Kretschmer

Date:

27 July 2018, 17:38:58


Am 27.07.2018 um 11:41 schrieb komala pelleti:
> Hi,
>
> We are using postgres 9.5.
>
> Iam not able to call vaccumdb from functions.: function check for 
> tables for databse if pct_dead > 100, then we are issuing a vaccum on 
> that table.
>
> getting error  .
>

vacuum can't run inside a transaction, and a function is a transaction. 
Why not using the autovacuum-feature?


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com