default | grid-3 | grid-2

Post per Page

Using Vacuumdb in PostgreSQL

I read in the PostgreSQL docs that vacuumdb or vacuum should be used on the databases every day. I have been running it manually the last couple of days and it has made a difference on query response times. I highly recommend using it.

To vacuum one database from the command line.


vacuumdb -d MyDB -v  -z -U postgres 




To vacuum one database from the command line.



vacuumdb -a -v  -z -U postgres 



-d = database name
-v = verbose output
-z = analyze
-U = username
-a = vacuum all databases

No comments

Error Page Image

Error Page Image

Oooops.... Could not find it!!!

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage