# Redshift

### Overview

• Redshift is based on PostgreSQL, but it’s not used for OLTP 

• It’s OLAP – online analytical processing (analytics and data warehousing) 

• Load data once every hour, not every second 

• 10x better performance than other data warehouses, scale to PBs of data 

• Columnar storage of data (instead of row-based) 

• Massively Parallel Query Execution (MPP), highly available 

• Pay as you go based on the instances provisioned 

• Has a SQL interface for performing the queries 

• BI tools such as AWS Quicksight or Tableau integrate with it

### Serverless

• Automatically provisions and scales data warehouse underlying capacity 

• Run analytics workloads without managing data warehouse infrastructure 

• Pay only for what you use (save costs) 

• Use cases: Reporting, dashboarding applications, real-time analytics...

<figure><img src="https://1722711354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwNXdoUkfmcozr29fRrfb%2Fuploads%2F6lymJMQalixRiE7HEQ5V%2FScreenshot%202023-12-13%20at%2023.04.13.png?alt=media&#x26;token=aa48afc0-0e88-407a-9cee-2efee9621455" alt=""><figcaption></figcaption></figure>