FlyData Blog

New Website!
In order to better communicate with both current and potential users, FlyData is releasing a new site, with more information, easier navigation, and an awesome design. As for the FlyData blog, we will be updating it on a regular basis. Although we are reinventing our look, the team is still retai...
How to improve performance of "UPSERT"s when running "COPY commands
TL;DR version: Add "COMPUPDATE OFF" and "STATUPDATE OFF" option to "COPY" for loading data to a staging table. With these options, you can skip post processes of "COPY", which may take a long time even if the number of loaded records is small. What is “UPSERT”? "UPSERT" is the operation to merg...
How to make EC2 MTU Settings Compatible with Amazon Redshift, Part 2
TlDR: If you are using DHCP and you want to permanently set the MTU for your instance, edit your DHCP client config. If you read our first article on setting the MTU on an EC2 instance for Amazon Redshift usage, then you may want to read this as well. After using the commands in the first articl...
How to make EC2 MTU Settings Compatible with Amazon Redshift
TLDR version: Ensure the MTU settings on your instances are set to 1500 if you’re using Redshift! Have you ever had connectivity issues running SQL queries against Amazon’s Redshift? Are you using one of the newer EC2 instance types available (C3, R3, etc)? Then this article might help you out!...
With Amazon Redshift SSD, querying a TB of data took less than 10 seconds
The AWS team announced the release of an SSD version of Amazon Redshift on January 24, 2014. To test out the specs of the newly released SSD version, we have performed some comparisons of its performance against the traditional HDD version of Amazon Redshift.
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.