Dropping data does not free space

[Timbo]

Hi,
A developer has filled up two of a six node cluster trying to load data, filled up node one then he tried again on node three, he has subsequently deleted the tables he loaded to, but this has not released any space.

I have run the following command to purge the data, but this has not worked:-
select make_ahm_now() ;
select purge() ;

Very new to Vertica, any idea how I can reclaim the space or find out what is using the storage on node 1 and 3?

Regards
Tim

[Timbo]

Sorry, meant to add this to the original post, current disk usage on each node:-
select
node_name,
disk_space_used_mb+disk_space_free_mb as disk_space_total_mb,
disk_space_used_mb,
disk_space_free_mb,
disk_space_free_percent
FROM disk_storage
WHERE storage_usage = 'DATA,TEMP';
node_name | disk_space_total_mb | disk_space_used_mb | disk_space_free_mb | disk_space_free_percent
-----------------------+---------------------+--------------------+--------------------+-------------------------
v_marketdata_node0001 | 1403702 | 1383503 | 20199 | 1%
v_marketdata_node0002 | 1403702 | 943063 | 460639 | 32%
v_marketdata_node0003 | 1403702 | 1394803 | 8899 | 0%
v_marketdata_node0004 | 1403702 | 936553 | 467149 | 33%
v_marketdata_node0005 | 1403702 | 945600 | 458102 | 32%
v_marketdata_node0006 | 1403702 | 998567 | 405135 | 28%
(6 rows)

[id10t]

Hi Timbo!

What returns next command?

Code: Select all

select evaluate_delete_performance('TABLE NAME')

[Rick]

move the ancient history mark?

also, have you committed the purge/deletion? (I cant remember if you have to commit or not lol)