SQL 8.2.7 - complete purged Database has still 3GB

[balllala]

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?

[ptrack pat]

Did you do a FULL vacuum/analyze?

[balllala]

Yes and not only once.

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

[ptrack pat]

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.

[balllala]

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?

[ptrack pat]

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.

[balllala]

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?

[ptrack pat]

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

delete from hand_histories ;

[balllala]

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...

[ptrack pat]

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