PT3 DB size is >>>>>> PT2

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

PT3 DB size is >>>>>> PT2

Postby admiralfluff » Tue May 27, 2008 11:32 am

Is this normal? After converting a PT3 DB, it's around 10x bigger than the corresponding PT2 DB file. I have both storing HHs.
admiralfluff
 
Posts: 3
Joined: Wed Mar 12, 2008 7:41 pm
Top

Re: PT3 DB size is >>>>>> PT2

Postby kraada » Tue May 27, 2008 3:17 pm

Yes, the PT3 database saves a LOT more data than the PT2 database. As a result, it is much larger.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY
Top

Re: PT3 DB size is >>>>>> PT2

Postby admiralfluff » Tue May 27, 2008 10:23 pm

I wasn't expecting a 4M hand DB to be over 33GB when it was like 2.5GB with PT2. Is there, could there, be any way to streamline this? Can I delete variables or columns from the SQL structure to save size without totally boning everything?
admiralfluff
 
Posts: 3
Joined: Wed Mar 12, 2008 7:41 pm
Top

Re: PT3 DB size is >>>>>> PT2

Postby WhiteRider » Wed May 28, 2008 5:17 am

No, I doubt it, unless you REALLY understand the structure of the complex PT3 schema.
You will almost certainly break something.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK
Top

Re: PT3 DB size is >>>>>> PT2

Postby Josh » Thu May 29, 2008 9:16 am

Make sure you vacuum your database, as that may dramatically decrease the size.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm
Top
Post a reply

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 21 guests

cron
highfalutin