Re: vacuum full for all databases

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ilia Chipitsine <ilia(at)paramon(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum full for all databases
Date: 2004-09-02 08:03:41
Message-ID: 4136D3DD.1060909@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ilia Chipitsine wrote:
> Dear Sirs
>
> I'm about to write plpgsql function which will "vacuum full" all existing
> databases. Below is an example how to get list of databases.
>
> What should I write instead of "raise notice" ?

> raise notice ''datname = %'',list.datname;

Something like:
EXECUTE ''VACUUM FULL '' || list.datname;

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilia Chipitsine 2004-09-02 08:12:41 Re: vacuum full for all databases
Previous Message Peter Eisentraut 2004-09-02 07:59:49 Re: vacuum full for all databases