pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding vacuumdb
2+ messages / 2 participants
[nested] [flat]
* Regarding vacuumdb
@ 2018-07-27 09:41 komala pelleti <p.komala@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: komala pelleti @ 2018-07-27 09:41 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
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
.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Regarding vacuumdb
@ 2018-07-27 11:38 Andreas Kretschmer <andreas@a-kretschmer.de>
parent: komala pelleti <p.komala@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Andreas Kretschmer @ 2018-07-27 11:38 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-27 11:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-27 09:41 Regarding vacuumdb komala pelleti <p.komala@gmail.com>
2018-07-27 11:38 ` Andreas Kretschmer <andreas@a-kretschmer.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox