I ran the following query on my database:
---------------
update bv_descriptions set description = REPLACE(description, '\\n', '\n');
commit;
---------------
It finished fine but to my surprise when I ran "df" on the server the
drive usage jumped from 44% to 60% which is additional 650MB.
I tried to restart the server but it didn't do any good, eventually I
tried to do a FULL VACUUM on that table and it did the trick and
cleaned the lost space.
I am still confused about what happened... What took these additional 650MB?
I could understand this phenomenon if it happened before I did
COMMIT... But why did it stay after COMMIT too?
Thanks