PDA

View Full Version : PostgresQL



Brein
10-16-2011, 01:36 PM
Hello,

(Not sure if this subforum is the right place for this thread).

My PostgresQL folder takes up a lot of CPU memory.
C:\Program Files\PostgreSQL\8.4\data\base contains about 1000 files (what are they?!) of about 20gb.

Can I delete them or will this get me in trouble? Is there a way to stop PostgresQL putting all this shit on my CPU? (I allready deleted 20gb of log files from the pg_log folder).

Thanks for the help!

Brein

Patvs
10-16-2011, 01:53 PM
The base folder contains the actual database. Don't delete any files in the /data folder and subfolders.


When every hand is imported the data from the hand is stored in hundreds of tables/indexes:
what are your holecards, list of players, action on the flop, etc.
1 million hands take up at least 10 GB of space.

Brein
10-16-2011, 02:11 PM
Ok, thank you.

Somewhere else I read that the files in C:\Program Files\PostgreSQL\8.4\data\pg_log could be deleted without difficulty. Isn't this true though? (Allready deleted them)...

Sarek
10-17-2011, 03:44 AM
Yes, contents of pg_log can be deleted.
And you can set Postgre to not write these logs in the future.
http://forums.holdemmanager.com/manager-general/8423-want-stop-postgre-creating-those-large-log-files-heres-how.html