> For the complete documentation index, see [llms.txt](https://huy312100.gitbook.io/software-development/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://huy312100.gitbook.io/software-development/cloud-service/aws/certificate/clf-c02/cloud-technology-and-services/database-and-analytics/redshift.md).

# 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&amp;token=aa48afc0-0e88-407a-9cee-2efee9621455" alt=""><figcaption></figcaption></figure>