How to optimize network throughput with AWS Redshift

ng flag

I've read about the sslcompression ODBC option in PostgreSQL, which seems to have some artifacts left in Redshift. But, I'm unsure if it is supported at all, and documentation seems to show that sslcompression has been deprecated for security concerns.

With that said, I have large queries that appear (in cloudwatch) to be transferring about 600MB/s between the Redshift cluster and an EC2 instance over a private VPC Endpoint.

This seems pretty fast, but it's not fast enough.

Are there any Redshift ODBC options which enable compression of the network data (perhaps something shared with PostgresSQL)? Are there any settings or other options (AWS Services?) to consider to drastically increase this throughput?

The Redshift cluster is a 4x Node ra3.xlplus. The EC2 instance is a z1d.2xlarge.


Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.