We have a table that has a blob column along with other simple fields. Number of rows is about 6K, and sum of length of the blob column for all rows accounted for about 30MB. however when we ran a query to find the actual table space occupied, it was about 10GB(Database size itself is 11GB). We are wondering if,
Would aborting transaction still block the space allocated for blob as though it's committed?
Though number of records did not increase significantly, size of database jumps from 2GB to about 1OGB in couple of days. Running the query to find the real table space showed that the single table which had the blob, had about 8GB of data (there are only 6K records and sum of datalength of the blobs gives only 30MB).
Anything we can do to resolve the space issue and address why sizeof of database has to increase so much?