sql – How can I perform the vacuum using the PostgreSQL?

sql – How can I perform the vacuum using the PostgreSQL?

Connect to the database and issue this command: VACUUM. This causes a run in lazy mode that can be used during normal production use. It is recommended you actually invoke it as vacuum analyze which will also update statistics.

If you want to see lots of detail, you can at the console type vacuum verbose

The more extreme form is vacuum full which causes heavy table locking and cannot really be used on a production system.

Source: http://www.postgresql.org/docs/8.1/static/maintenance.html

If youre running a recent version of PostgreSQL you likely have auto-vacuum running so the benefits of running VACUUM manually may be very minimal.

sql – How can I perform the vacuum using the PostgreSQL?

Leave a Reply

Your email address will not be published. Required fields are marked *