Re: pg_* files are too large for empty database. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_* files are too large for empty database.
Date
Msg-id 21565.959621029@sss.pgh.pa.us
Whole thread Raw
In response to pg_* files are too large for empty database.  (Denis Perchine <dyp@perchine.com>)
List pgsql-hackers
Denis Perchine <dyp@perchine.com> writes:
> And lots of pg_* indices are incredibly large. Like:

Longstanding problem --- vacuum doesn't have any way to shrink indexes.
This is on the TODO list but there is lots of higher-priority work.

If you are cleaning out your database entirely anyway, I'd suggest just
dropping and recreating the whole database ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Vacuum now uses AccessShareLock for analyze
Next
From: Daniel Kalchev
Date:
Subject: Re: Vacuum now uses AccessShareLock for analyze