vertica windows vsql is slowing down when doing gzip result dump
I am using vertica windows vsql client to export result from vertica to client's machine with gzip format.
used below command , but it slows down the export process.
C:\Test\vsql.exe -U <user> -w <password> -h <host> -F "|" -At -c "<Select query>;" | "C:\Test\gzip.exe" -f > "C:\Temp\Results.gz"
Can anyone suggest how to make the export faster.