Re: Regarding vacuumdb

Andreas Kretschmer <[email protected]>
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]> 

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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.