vertica windows vsql is slowing down when doing gzip result dump

daole

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

Adrian_Oprea_1

   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.