Skip to main content
Question

TPC-DS Performance Test When Vertica Uses S3 as External Storage

  • March 18, 2025
  • 1 reply
  • 5 views

wxhadmin7449

During our testing process, we observed the following phenomenon when Vertica interfaced with our S3 storage system using DNS resolution for the "tpc-ds deptoff user=3" test:
When the storage system had 3 nodes, each node achieved load balancing. However, with configurations of 2, 4, 5, or 6 nodes, only one node experienced exceptionally high workload while other nodes maintained very low utilization rates throughout the entire testing period.
We would like to consult your team regarding Vertica's DNS resolution implementation to verify whether this aligns with our test results. For reference, we have already enabled database load balancing using the following SQL statement:
`SELECT SET_LOAD_BALANCE_POLICY('ROUNDROBIN');`

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 18, 2025

we will need scrutinize to review how connection load balance is working.  please open a support case.