vacuumdb -a -f - Mailing list pgsql-admin

From D Kavan
Subject vacuumdb -a -f
Date
Msg-id BAY102-F7BFF29DBBA83A39A55751D1B10@phx.gbl
Whole thread Raw
Responses Re: vacuumdb -a -f  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hello,

Even though I run vacuumdb -a -f every night with no exceptions or problems,
my database size remains 5.6 GB.  After I do a dump/restore, the new
database size is 4.0 GB.  How could that be possible?   That's a significant
amount of space.  If I can clean up my existing databases by 30%, I'd be in
much better shape.

Has anyone else noticed this?

Thanks,
~DjK



pgsql-admin by date:

Previous
From: asif ali
Date:
Subject: unsubscribe
Next
From: Chris Hoover
Date:
Subject: Any way to see what queries are currently running?