How to delete some of my database and keep the stats ?

[radotdr]

Sorry if there is another threat like this, but I couldnt find it.

Can you explain me how to make my database smaller and to keep the stats, because my database is now over 20GB and I dont kno how to move it on another partition :( .

What are the options ?

Thank you!!!

[morny]

Delete but keep stats http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107

Delete completely http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=152

After doing it try a vacum http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163

or look at these options http://www.linuxinsight.com/optimize_postgresql_database_size.html