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