Custom vacuum

From: Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br>
To: "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org>
Subject: Custom vacuum
Date: 2010-07-20 18:34:50
Message-ID: 003e01cb283a$3fa1e5a0$6500a8c0@gibon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I want perform VACUUM on specific tables. This tables are result of query in my database (select tablename from mytablesvacuum). I tryed use a cursor
on function, but i receive message that vacuun can't run in function.

Any idea to do this?

tks
Fábio Henrique Gibon
Comex System Consultoria

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2010-07-20 19:10:34 Re: Autovacuum on defined interval
Previous Message Joshua D. Drake 2010-07-20 17:03:49 Re: Autovacuum on defined interval