PDA

View Full Version : Why the database doesn't become smaller after purging hands?



HHLWX1
04-23-2013, 07:44 AM
HM2.After purging hands(about 1/3 of the whole),the size of the database remains the same,though many hands have been deleted.Why?How can I make the database smaller?

udbrky
04-23-2013, 10:32 PM
1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

Please try again.

udbrky
04-23-2013, 10:33 PM
1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

Please try again.

HHLWX1
04-24-2013, 09:29 AM
Thanks.One more question:could I just create a new database and delete the former one to free up the disk space?coz the maintenance really takes a lot of time.

DogNamedBluff
04-24-2013, 10:23 AM
If you do not want to save the database you can remove it from your computer completely.

1) Delete database in the HM2 Database Manager. http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29

2) Delete the specific database folder inside this folder -
Windows 7/8/Vista: C:\Users\username\AppData\Roaming\HoldemManager\Da tabase
You must show both hidden files and check unhide system files. See this:
Show hidden files (http://windows.microsoft.com/en-US/windows7/Show-hidden-files)

Windows XP: C:\Documents and Settings\User_name\Application Data\HoldemManager\Database
For showing hidden files and unhide system files, see this:
Microsoft Corporation (http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_fcab_show_file_extensions.mspx?mfr=true)

3) Delete the database from PGAdmin III - pgAdmin: PostgreSQL administration and management tools (http://www.pgadmin.org/index.php)