As in the today's world, volume of data is increasing significantly along with the need of real time analytics on the data. This is driving unprecedented demand for Big Data/No SQL type of databases. More and more requirements are coming to migrate from traditional (relation) databases to more Morden database. The good news is there are plenty of options like Mongo, Cassandra , Dynamo DB, Redshift , Hadoop etc . But the challenge is, they all solve a special needs and selecting right database depends on the actual use cases , type of data etc. Here I am covering a generic use case of migration from Postgres (or any other relational databases) to Redshift. We will focus on 2 key area .. 1) Fundamental Architecture difference between Postgres and Amazon Redshift, especially the way Storage and Scaling is managed. Storage played a very important role when it comes to performance as most of the time its I/O that's impact performances. 2) Best Practices in usin