Very Big DB

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Post a reply

Very Big DB

Postby JMagnat » Wed Jan 13, 2010 3:00 pm

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
JMagnat
 
Posts: 3
Joined: Sun Nov 16, 2008 4:38 pm
Top

Re: Very Big DB

Postby kraada » Wed Jan 13, 2010 3:09 pm

Our databases are large because they contain an awful lot of information. There isn't really any way to compress it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY
Top

Re: Very Big DB

Postby JMagnat » Wed Jan 13, 2010 3:33 pm

thanx for your fast reply... but this is a pitty... I use SSDs for this db. :|
JMagnat
 
Posts: 3
Joined: Sun Nov 16, 2008 4:38 pm
Top

Re: Very Big DB

Postby LVgamb00ler » Thu Jan 14, 2010 1:11 pm

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=16258

I hope that helps
LVgamb00ler
 
Posts: 32
Joined: Thu Apr 03, 2008 7:57 pm
Location: Las Vegas
Top
Post a reply

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 15 guests

cron