Hi,
while creating an index on billion records table i have canceled creation because index took me ~70GB of space.
When I looked into disk space i saw that space is still occupied , and the index doesn't exist.
I have started full vacuuming but it still runs after three days, so i wanted to ask if there is some other way to free that space.
Would it be better if i truncate table and insert all records again (costs ~1.5 day) or is there some other solution?
Thanx in advance
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me