[aplaws - Developing on APLAWS+] postgres data size

[Aplaws - Dev mailing list]

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4441752
By: oliew

hi there
my database backs up to 650MB in a TAR file
ive been running out of disk space recently and looked in my DATA folder inside
pgsql and its 33GB!!!

the site isnt that big
there is about 20 1GB files that were created july 12th 2007, im wondering if
this i was when i did a PG vaccum clean etc....
bit unsure why there is so many big files... anyone have any ideas??
thanks
Oli

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Aplaws-devel mailing list
Aplaws-devel@...
https://lists.sourceforge.net/lists/listinfo/aplaws-devel

[Aplaws - Dev mailing list]

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4442530
By: pboy

Hi Oli,

sounds a bit strange. Out database backup is 500mb and a cu -s -h ./ in the
data dir is 350mb. And we do a vacuumdb -z every night.

Perhaps you should check what happens if you create a new database and execute
a restore.

Peter

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Aplaws-devel mailing list
Aplaws-devel@...
https://lists.sourceforge.net/lists/listinfo/aplaws-devel

[Aplaws - Dev mailing list]

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4443308
By: oliew

Hiya,
yep seems strange to me too.
If i go into my new postgres server which runs the same database only about
3 weeks older and do a du
the folder size in data is 700mb

the backup on the live site last night is 700mb too! so how can 34GB be compressed
into 700mb im confused.
this is the only database on the live site too.

i suppose i could restore into a new database but what if the restore trys to
make a nother 34gb database i only have 10gb free :o)

:)
Oli

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Aplaws-devel mailing list
Aplaws-devel@...
https://lists.sourceforge.net/lists/listinfo/aplaws-devel

[Aplaws - Dev mailing list]

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4453383
By: oliew

restored the backed up DB into the new server data folder is 700mb..
no idea where that 33gig came from!!!!!!! ah well ill wait for the new server
to be finished.
:)

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Aplaws-devel mailing list
Aplaws-devel@...
https://lists.sourceforge.net/lists/listinfo/aplaws-devel

[Aplaws - Dev mailing list]

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4620563
By: infoaxon

We are facing the same problem....was there a final solution to this. We are
puzzled why the DB size should be so large. I am pretty sure this does not reflect
the actual data we have added to the CMS...

Shubham
InfoAxon Technologies

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Aplaws-devel mailing list
Aplaws-devel@...
https://lists.sourceforge.net/lists/listinfo/aplaws-devel