After purge more disk space is used

[J0FF4]

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]

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]

Had logging collecting turned off, PG_log folder size was 1kb, deleted that
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]

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]

Will this pg-xlog folder increase everytime i purge?

[Sarek]

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]

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.