We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


vertica windows vsql is slowing down when doing gzip result dump — Vertica Forum

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