I have a table with list partitions on it. When i insert data i see that all the partitions have default initial size of 8 MB and I also noticed that when i truncate full table and check size it still shows 8MB for each partition even when they are empty.
Can someone help me understand what could be causing these paritions to have intial size of 8MB? Is there a way i can change this to use size based on partition size and not default to a value? And why is size not reclaimed or set back to 0 after truncating table?
TRUNCATE TABLE TABLENAME;
ALTER TABLE TABLENAME TRUNCATE PARTITION PNAME DROP STORAGE;