How can I shrink a postgresql database?

Question

I have an instance of Postgresql that is 374GB!

It's the dbase for an Event Sentry Application, but since Event Sentry is just a monitoring tool, don't see how it can require this much data. There are hundreds of 1 Gig files in the default database folder. Any assistance on this one is greatly appreciated! Carl

You can use the statements from the Postgres wiki to find the tables that take up the space: wiki.postgresql.org/wiki/Disk_Usage — user330315
– user330315, Commented Mar 15, 2016 at 18:55

Rodrigo Hjort · Accepted Answer · 2016-03-16 02:01:24Z

4

Take a look at this operation called 'vacuum' in PostgreSQL:

http://www.postgresql.org/docs/9.5/static/routine-vacuuming.html

However, in some situations even vacuuming doesn't solve that much. In that case, the best to do is make a dump, recreate the database and restore it.

answered Mar 16, 2016 at 2:01

Rodrigo Hjort

3113 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I shrink a postgresql database?

I have an instance of Postgresql that is 374GB!

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

I have an instance of Postgresql that is 374GB!

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related