| From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
|---|---|
| To: | Josh Close <narshe(at)gmail(dot)com> |
| Cc: | PgSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: vacuum schema |
| Date: | 2004-10-19 05:48:34 |
| Message-ID: | 83E8B19A-2192-11D9-A4B4-000D93AE0944@sitening.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ah, yes. You're right.
Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.
-tfo
On Oct 18, 2004, at 6:02 PM, Josh Close wrote:
> On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
> <tfo(at)sitening(dot)com> wrote:
>> Are you looking for something different than vacuumdb?
>>
>> http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
>>
>> -tfo
>
> I think so. As far as I can tell, you can either vacuum a whole db, or
> individual tables. But not a whole schema.
>
> -Josh
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-10-19 06:02:21 | Re: Numeric user names |
| Previous Message | Aaron Glenn | 2004-10-19 05:39:12 | Re: clustering |