PostgreSQL is HUGE on my harddrive

[puyanwei]

Here is my windirstatanalysis of space allocation;

[ img ]

PG Admin is also showing that I have 2 databases, postgres and PT3DB (which is linked to PT3), do you think this is significant?

[ img ]

[ img ]

[WhiteRider]

You're using the PostgreSQL 9.0.0 beta, are you?
It may be that that uses more space, or it may have additional logging on by default since it's beta software.

The 'postgres' database is always there - that's nothing to worry about.

[puyanwei]

Version 1.12.0 Beta.

[kraada]

We haven't tested PostgreSQL 9.0's beta revisions yet - which is what it shows in the PGAdmin view you pasted.

The postgres database is always there by default though, it controls other things and is required for proper PostgreSQL functioning.

[puyanwei]

So do you think that is the reason why my database is so big? Seems kinda weird reason...

[WhiteRider]

It's possible - since it's still beta software there could be additional logging for instance, or another reason that more space is used.

[Darvini]

I have only 600 k hands but my PostgreSQL folder is 90 GB! How can I free space from it? 81 GB of it is in the pg_log folder.

And is it normal to have 10 postgres.exe processes running at the same time while autoimporting?

[kraada]

You can safely delete all but the most recent file in the pg_log folder.

[Darvini]

The most recent file is only 1 KB as most of the files are over 10 MB so you are sure I can delete them? Sorry to ask again, but just a little worried about deleting 81 GB. :/ If they are not needed why arent they erased automatically?

[Darvini]

Are these the log files that are created with the logging enabled? If they are cant I just turn the logging off and stop the generating of these files on regular bases? Because they have been building up 5 GB on some days!