Ways to minimize S3 fetches and without affecting performance?

kxu

Right now, we access data and run daily loads on our database cluster (ETL Load) and monitor this data by populating dashboards with information from the last three months. How can we design this kind of query to minimize fetches to the depot without sacrificing performance?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat

s_crossman

Hi,
A good reference as a starting point that may provide a lot of insights is this Knowledgebase article. https://www.vertica.com/kb/ETL_Considerations_in_EON_Mode/Content/BestPractices/ETL_Considerations_in_EON_Mode.htm
I hope it helps.