Wednesday, April 28, 2004

postgresql

If you are a postgresql user/admin and you've never used `vacuum analyze` - then you are in for a treat. The `vacuum` command (or the vacuumdb shell script) will garbage collect your db. If you run it together with the analyzer option, it will calculate statistics for use by the optimizer...
As an example, I just gained a factor 30 of increased query speed on a table in one of my databases...

All hail postgres..

No comments: