PDA

View Full Version : After purge more disk space is used



J0FF4
08-02-2012, 06:53 PM
My Base folder size was 11.4GB and Data folder 13.7GB. I decided to purge 600k observed HHs leaving everything at it's default settings. Then i did Vacuum Full?Analyze through pgadmin.exe.

My current Base folder size is still 11.4GB but Data folder has increased due to PG_XLOG folder to 14.5GB.
Ran vacuum again but no change. Desperately reindexed, but to no avail.
Yay!

Any thoughts on what happened? I'm using HM1 with PGL 8.4 on Win7 x64 6GB i7 machine.

Patvs
08-02-2012, 07:02 PM
Delete the contents of the data/pg_log folder

Don't delete the content of the data/pg>xlog folder. What's the size of this folder for you though?

J0FF4
08-02-2012, 08:41 PM
Had logging collecting turned off, PG_log folder size was 1kb, deleted that :D
No change to database size and xlog folder is 3.06GB now lol. The xlog folder contains 196 files each 16.384kB and an empty archive_status folder.

netsrak
08-03-2012, 03:41 AM
Usually the vacuum/full should give some free space so not much else you can do.
You can try a defrag of your HDD after stopping the postgresql service or via booting with a live cd.

J0FF4
08-03-2012, 03:51 AM
Will this pg-xlog folder increase everytime i purge?

Sarek
08-03-2012, 04:27 AM
That folder contains logs postgres writes - and they can NOT be deleted.
If you are going to do very large purge - instead consider creating new database and import in it only HHs you need. Will be faster and better.

Patvs
08-04-2012, 10:11 AM
There have been reports where deleting the xlog files---> PostgreSQL will stop running.

I'm using PostgreSQL 9.0.x and cannot duplicate this. So I have just deleted all my xlog 16 MB log files, and it didn't result in any issues.