View Full Version : How Big Is The Average Database?
riverulots
05-10-2009, 05:29 PM
Is there a way to check how big your database is?
I'm looking to share a database between two computers and am looking to buy an external hard drive, but I don't know what size capacity is ideal. I'm currently looking at one that is 250 GB, will that be enough?
morny
05-10-2009, 07:05 PM
Go to Program Files\PostgreSQL\8.x\Data and right click the data folder as this is the size of your database
riverulots
05-11-2009, 03:35 AM
Go to Program Files\PostgreSQL\8.x\Data and right click the data folder as this is the size of your database
Thanks. So how big is the average database? I want to buy a suitable HDD.
Juuza
05-11-2009, 12:25 PM
My database is massive with who knows how many millions of hands in it, and it only takes up about 8 gigs or so if I remember correctly. 250GB will be more then enough to last the rest of your lifetime.
morny
05-11-2009, 06:03 PM
Well i dont know about the rest of your lifetime, if you trim your database once every month/quarter 250gb should be fine, id go with 500gb since usually the difference between 250 and 500 isnt alot
abstractls
05-15-2009, 05:19 AM
any way to check and see how many hands you have in your database?
morny
05-15-2009, 03:48 PM
Please see this FAQ http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=19
snakkero
05-15-2009, 07:55 PM
My database is massive with who knows how many millions of hands in it, and it only takes up about 8 gigs or so if I remember correctly. 250GB will be more then enough to last the rest of your lifetime.
How is it possible? I installed HEM today and imported about 1kk hands. It takes up about 6gb on my hard drive. Is it possible to compact it?
Juuza
05-16-2009, 03:43 AM
I was looking at the size of the backup I made. My mistake. I guess when you back it up it compacts it some way.
snakkero
05-18-2009, 12:16 PM
I installed HEM today and imported about 1kk hands. It takes up about 6gb on my hard drive. Is it possible to compact it?
support?
GoAheadPutMeOnAK
05-18-2009, 03:54 PM
Ive had my database since November. Its around 100GB, and is now extremely extremely slow.
I keep getting errors when I try to vacuum the database or by compacting it. Before I left for work today I set HEM to purge all of my hands older than 1 month. If that doesn't work, I'm just going to delete my entire database and start from scratch.
I have roughly 10million hands that the purge is working on.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.