Compression Method

[Kevin J]

I couldn't find anything on the difference of the different compression methods. Which one should I be using?

I've been using vacuum/analyze, and that seems to be fine, but when should I use vacuum/analyze 'full'? Or when can I just use vacuum or vacuum 'full'?

Thanks.

[ptrack pat]

It doesn't hurt to use the full v/a - the full option is basically something you would want to use if you have deleted a lot of data from the database because it will do more of a clean up than the normal vacuum.