Vacuum Full by Scheme
Hello,
There is some development to use the vacuum full by scheme?
Ex: *vacuumdb -d postgres **-parameter public*
In databases with thousands of tables and multiple scheme, it would be
interesting to have this feature.
*Filho **Arrais *
Analista de Tecnologia da Informação
MBA em Gestão de Tecnologia da Informação
On Thu, May 12, 2016 at 7:31 AM, Filho Arrais <arraisfilho@gmail.com> wrote:
There is some development to use the vacuum full by scheme?
Ex: vacuumdb -d postgres -parameter public
In databases with thousands of tables and multiple scheme, it would be
interesting to have this feature.
No that I know of. The only way to achieve that now is to use a script
that fetches the list of tables in schema first and runs VACUUM on
those tables individually, as VACUUM cannot be run in a stored
procedure.
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers