The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.





  •    You actually export from your server to your windows client machine, so your newtwork creates all the contention. 

       Even thou you zippit the data comes to your windows server uzipped and then once there it will zipp.


    You should do this in the vertica server , zipp it and then move it to your windows client as a zipped file.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file