| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | David Link <dlink(at)soundscan(dot)com> |
| Cc: | Lee Crampton <lee(at)avbrief(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Easy way of pruning pg_data? |
| Date: | 2001-10-16 15:18:22 |
| Message-ID: | m3vghfsjep.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Link <dlink(at)soundscan(dot)com> writes:
> What are those files? my $PGDATA/base only contains subdirectores, one
> for each database name. Are those your database names?
Recent versions of Postgres (since 7.1 IIRC) store the databases by
IOD number instead of by name (to avoid certain problems with
renaming).
The only way to "prune" the files under your data/base directory is to
VACUUM and to drop and recreate your indexes, both of which will free
up space.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Flancer | 2001-10-16 15:24:12 | To Postgres Devs : Wouldn't changing the select limit syntax .... |
| Previous Message | Richard Welty | 2001-10-16 15:16:50 | Re: WWW interface for postgres |