PokerTracker

Is it possible that PT+SQL database age with time, so you have to make a knew one after a periode of time?
I did everything to try to reduce the space needed for a database that has no longer any data in it, but it didn´t work.

I´m concerned about it, because one of my mining database has already 18GB altough i purge old hands and vakuum it periodical.

Do you know where this problem comes from and how i can fix it without creating new databases?

Did you do a FULL vacuum/analyze?

Yes and not only once.

So it seems you don´t have any suspicion to get that database back to fetus size.

A full vacuum as opposed to just doing a normal v/a should free up the disk space that was taken by the data that was purged. If it's not doing that then I don't know why that is so.

With PgAdmin i found out that the biggest part of space used is for the hand_histories (i think the txt for export). They seem not to be delete by purge. Could this be?

You can use the query tool in pgAdmin to delete the records from that table....

delete from hand_histories ;

Then do a full v/a after that.

i get this error message.

ERROR: unterminated quoted identifier at or near ""
delete from hand_histories;
"
SQL state: 42601
Character: 1

I accidentally change the Position of one Column. Could this be the reason?

Don't use the double-quotes, it should be

delete from hand_histories ;

will there be any Problem without this column?

After deleting it´s gone, the files too. But the database still believes to be that big...

You have deleted just the data from that table, that's all. Did you do a full v/a after deleting from this table?