DB - Files Sizes ?!

[00000815]

on my disk are 3 files holdemmanager.sql, nearly 12 GB each, 1more file holdemmanager.sql, about 6GB and folder C:\Program Files (x86)\PostgreSQL\8.4\data contains another 20GB of files

DB contains like 2.5M hands and 35k Tourneys

How is this possible ?

[Patvs]

1 million hands should take up about 10 GB of diskspace.

Make sure you have logging turned off and delete the contents of you log folder (and delete old databases you no longer use)

Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

[00000815]

I only have one database and no logging enabled.

Can i delete any of the 'holdemmanager.sql'-files and if so which one?

Is there anything in the folder 'SQL/data' that can be deletet? There are 409 files, mostly smaller ones but a few really big ones, f.i. 17202 or 17202.1 of 1GB?

[Patvs]

You can't delete anything from the C:\Program Files (x86)\PostgreSQL\8.4\data folder.

Are the holdemmanager.sql files located in a different folder?

Try to vacuum/reindex the database to make it smaller.

[00000815]

Are the holdemmanager.sql files located in a different folder?
C:\Users\00000815\AppData\Local\Temp\08f9e2b3-bfba-4d28-abc4-2f13c312b05d\dbs
C:\Users\00000815\AppData\Local\Temp\0fe648d9-5d28-4d70-b21b-5f6f19a618af\dbs
C:\Users\00000815\AppData\Local\Temp\0fe648d9-5d28-4d70-b21b-5f6f19a618af\dbs
and
C:\Users\00000815\AppData\Local\Temp\bc40e8b1-9ffe-4828-8fa2-509b00be9434\dbs

[Patvs]

You can delete those files.

They're a temp. file either created when you import a lot of hands (and should be deleted if you reboot the computer).... or created when you vacuum/analyse or create a backup/restore. If you abort any of those processes it's common they're not deleted.

[00000815]

this works, ty


btw
how much disk space do i safe when i purge lets say a million hands
and does the speed increase significantly

i mean is it worth it?

[Patvs]

Purging them (to lose the ability to replay them) will only save you 7% of space. (it will only delete 1 of the 45 indexes).

Speed: could increase 10% after purging if you vacuum the database. Similar to defragging your harddisk.
If you have a slow harddisk, you'll notice the performance gain. But it's not really worth it.

[00000815]

Purging them (to lose the ability to replay them) will only save you 7% of space. (it will only delete 1 of the 45 indexes).

Speed: could increase 10% after purging if you vacuum the database. Similar to defragging your harddisk.
If you have a slow harddisk, you'll notice the performance gain. But it's not really worth it.

okay, thx. happy enough to have back like 30% of my SSD just by deleting these crazy duplicate files

[00000815]

... or created when you vacuum/analyse or create a backup/restore. If you abort any of those processes it's common they're not deleted.
not true, seems backing up creates a 12GB temporary file which isn't deleted even when backup process is finished properly

[Sarek]

Temporary files can be deleted after finishihg any PC software works. Not only HM and Postgre.