Vertica is slow
We have 36 node cluster and few hours in a day system is very slow and it takes atleast 30 min to load a file (50MB) to table. Usually it take 2 mins. During this time, could notice performance hit in all the queries too.
like Select count(*) from table etc
We have 20% free disk space in all the nodes. This performance hit happens few times in a day.
Can you please suggest