Very Big DB

Posted:
Wed Jan 13, 2010 3:00 pm
by JMagnat
Hi,
I imported e.g. 10 mio hands to my postgresql. The database size is now 100 GB .
Is this possible? Could I minimize this db?
Yea... this size is including housekeeping. :shock:
CU,
JMagnat
Re: Very Big DB

Posted:
Wed Jan 13, 2010 3:09 pm
by kraada
Our databases are large because they contain an awful lot of information. There isn't really any way to compress it.
Re: Very Big DB

Posted:
Wed Jan 13, 2010 3:33 pm
by JMagnat
thanx for your fast reply... but this is a pitty... I use SSDs for this db. :|
Re: Very Big DB

Posted:
Thu Jan 14, 2010 1:11 pm
by LVgamb00ler
Quite a while ago, when I spent a lot more of my time with online poker, I wrote a post about saving space.
http://www.pokertracker.com/forum/viewtopic.php?f=15&t=16258I hope that helps