run vacuum from within a function

From: Hugo <htakada(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: run vacuum from within a function
Date: 2005-11-10 20:53:55
Message-ID: f3d9ba990511101253w5d23459eu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi everybody,

Is it possible tu run vacuum from a plpgsql function ? I have a process that
copies a lot of data from a csv file with the copy command and at the end of
the function I would like to force a vacuun, is that possible.

thanks in advance

Hugo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-10 21:11:04 Re: PREPARE TRANSACTION and webapps
Previous Message Matthew T. O'Connor 2005-11-10 20:43:44 Re: Performance of autovacuum and full vacuum of database