View Full Version : How to delete some of my database and keep the stats ?

02-06-2009, 06:40 AM
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!!!

02-06-2009, 03:48 PM
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