PDA

View Full Version : PostgreSQL taking up too much space



Glamdringer
10-10-2009, 12:38 PM
I keep running out of space on drive C, and now that I checked it I see the PostgreSQL folder is taking up 17 GB.

Is this normal?
What can I do to decrease its size?

netsrak
10-10-2009, 02:02 PM
This is pretty normal if you have more than some hands in your database.
You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
and you can delete all files in the postgresql subfolder data\pg_log.

If you plan to have more hands in your database you should move the postgresql installation to a different partition:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101

and check the performance tips from the link in my signature.