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

Hi,

 

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.

 

Thanks

Ajit

Comments

  •    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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.