Reddit
reddit.com › r/aws › deciding between rds and redshift for "data warehouse"
r/aws on Reddit: Deciding between RDS and Redshift for "data warehouse"
January 27, 2023 -
Hi all,
I have a business request to ETL data from several sources into a data warehouse to run BI tools on (Tableau or PowerBI for example).
The dataset isn't that big, 400GB growing 4GB per week. I can't find any good explanation on if I should use RDS or Redshift to store the data.
Can anyone with experience on this topic guide me please?
Thank you!
Top answer 1 of 2
6
You can go for Aurora first then migrate to redshift when your data gets around 5Tb or so, that’s my estimate in which the query starts to get slow in a rds and dwh will be much faster
2 of 2
6
RDS stores rows of data near each other, ideal for transactional processing, whereas Redshift (and many other data warehouses) uses a columnar storage where columns of data are stored near each other - ideal in terms of performance for read-only reporting queries that BI tools will be using. So I think you might need to establish whether the queries your BI tool will be using will always be over indexed columns if you want to store it in RDS, or whether you need to be flexible in which columns will be used in the where clause of the queries your BI tool with run, (potentially over unindexed columns if you were to store it in RDS, in which case a data warehouse will be more performant). So - it depends on what your performance and pricing requirements are with respect to the types of queries your BI tool will be running.
Is Redshift still worth choosing in 2026? Here’s what I’m seeing in real teams. Dec 5, 2025
r/aws 7mo ago
Should I consider Redshift as datawarehouse when building a data platform? Jan 28, 2025
r/dataengineering last yr.
Easy and cost effective way to sync data from RDS Postgres to Redshift Feb 12, 2022
r/dataengineering 4y ago
Amazon Web Services
aws.amazon.com › analytics › amazon redshift › pricing
Amazon Redshift Pricing
1 week ago - For RG or RA3, data stored in managed ... price per TB per year is calculated only for the compute node costs. Amazon Redshift has zero-ETL integrations with online transaction processing (OLTP) databases and enterprise applications, removing the need to build and manage extract, transform, and load (ETL) pipelines. Supported databases include Amazon Aurora, Amazon DynamoDB, and Amazon Relational Database Service (Amazon RDS), and Oracle ...
amazon web services - Reporting AWS Tools RDS or Redshift? - Stack Overflow
My app is reporting stuff like dashboards and filters, based on filters forecast/sales etc data have to be shown. We build the UI with Angular or a similar UI. This is going to be in AWS cloud. What More on stackoverflow.com
AWS RDS, Amazon Athena, Amazon QuickSight and Amazon Redshift
With its Massively Parallel Processing ... the best price performance at any scale for complex BI and analytics workloads. Using Amazon Redshift, you can also directly query data in open formats (such as Parquet or ORC) in the Amazon S3 data lake, or query data in operational databases, such as Amazon Aurora and Amazon RDS PostgreSQL ... More on repost.aws
1
0
March 30, 2023Deciding between RDS and Redshift for "data warehouse"
You can go for Aurora first then migrate to redshift when your data gets around 5Tb or so, that’s my estimate in which the query starts to get slow in a rds and dwh will be much faster More on reddit.com
10
6
January 27, 2023DynamoDB or Aurora or RDS?
Try this search for more information on this topic. Comments, questions or suggestions regarding this autoresponse? Please send them here . I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
36
21
December 2, 2024Should I use RDS or Redshift?
It depends on your specific needs. If you need a relational database for an OLTP workload, then you should use RDS. If you need a data warehouse for an OLAP workload, then you should use Redshift.
boltic.io
boltic.io › home › blog › aws redshift vs rds
AWS Redshift vs RDS - Key Features, Comparison & Use Cases
What is the difference between RDS and Redshift?
RDS is a relational database that is designed for OLTP workloads. Redshift is a data warehouse that is designed for OLAP workloads.
boltic.io
boltic.io › home › blog › aws redshift vs rds
AWS Redshift vs RDS - Key Features, Comparison & Use Cases
What is the difference between AWS RDS and Redshift?
AWS RDS is a managed service for relational databases (e.g., MySQL, PostgreSQL, Oracle, SQL Server) designed for transactional workloads.
Redshift is a cloud data warehouse designed for analytical workloads, handling large-scale data queries and complex aggregations.
Redshift is a cloud data warehouse designed for analytical workloads, handling large-scale data queries and complex aggregations.
hevodata.com
hevodata.com › home › blog › data warehousing
Amazon Redshift vs RDS Comparison | Hevo
AWS Databases Explained Simply: RDS vs DynamoDB vs ...
01:42
AWS RDS vs Redshift (2026) - Which One Is BETTER? - YouTube
02:21
AWS RDS vs Aurora vs Redshift (2026) - Which One Is BEST? - YouTube
07:42
RDS vs Redshift - YouTube
03:18
Redshift Or RDS? - Emerging Tech Insider - YouTube
49:16
AWS Hands on lab - Zero-ETL - RDS MySQL and Amazon Redshift - YouTube
DEV Community
dev.to › tomerbendavid › comparing-postgre-rds-vs-redshift-pricing-estimation-23o4
Comparing Postgre RDS vs Redshift Pricing Estimation - DEV Community
February 26, 2025 - Redshift offers on-demand nodes (e.g., $1.30/hour for ds2.xlarge) and serverless options ($0.375/RPU-hour), with storage at $0.024/GB-month. For 1 TB, a ds2.xlarge setup might cost $973 monthly, while serverless could reach $1,119 for similar ...
TechTarget
techtarget.com › searchcloudcomputing › tip › When-to-use-Amazon-RDS-vs-Redshift
When to use Amazon RDS vs. Redshift | TechTarget
RDS and Redshift differ in key areas, including underlying design, provisioning and scaling approaches, data access and cost.
Integrate.io
integrate.io › home › blog › big data › what is the difference between aws redshift and rds?
What Is the Difference Between AWS Redshift and RDS? | Integrate.io
July 21, 2025 - If you're just getting started with your first database, then RDS starting at $0.25/hour is a great option, but as your needs grow, so will its price tag until Redshift becomes more cost-effective eventually.
Satori
satoricyber.com › home › amazon redshift vs. amazon rds
Amazon Redshift Vs. Amazon RDS - Satori
April 22, 2023 - Users can use Amazon RDS’ services for a meager cost. Rest assured that they will only get charged for the resources they use. That is all there is to it. Let us examine these managed services based on essential characteristics that a data architect will consider when selecting one. Customers can scale Redshift and RDS according to their budget and performance requirements.
Medium
medium.com › @Tom1212121 › comparing-postgre-rds-vs-redshift-pricing-estimation-805d0b927692
Comparing Postgre RDS vs Redshift Pricing Estimation | by Tomer Ben David | Medium
February 26, 2025 - Redshift offers on-demand nodes (e.g., $1.30/hour for ds2.xlarge) and serverless options ($0.375/RPU-hour), with storage at $0.024/GB-month. For 1 TB, a ds2.xlarge setup might cost $973 monthly, while serverless could reach $1,119 for similar ...
Hevo Data
hevodata.com › home › blog › data warehousing
Amazon Redshift vs RDS Comparison | Hevo
January 27, 2026 - ... In a nutshell, RDS offers better performance when it comes to queries that do not test its limits; To be specific, queries that do not span across millions of rows offer better performance in RDS.
Boltic
boltic.io › home › blog › aws redshift vs rds
AWS Redshift vs RDS - Key Features, Comparison & Use Cases
January 14, 2026 - If you're looking for a cheaper option for storage and compute, RDS is the way to go. However, if you need more scalability and power, Redshift is worth the investment. Keep in mind that with Redshift, you'll typically use multiple nodes, which ...
CloudZero
cloudzero.com › home › blog › aws redshift guide: use cases, pros and cons, and pricing
AWS Redshift Guide: Use Cases, Pros And Cons, And Pricing
November 1, 2024 - Here’s a quick look at the differences between Amazon Relational Database Service and Amazon Redshift. Amazon RDS is a fully managed Database-as-a-Service solution while Redshift is a managed data warehouse platform (and supports a data lake approach as well).
Beekeeper Studio
beekeeperstudio.io › blog › amazon-rds-vs-redshift
Comparing Amazon RDS and Redshift: Key Differences and Use Cases | Beekeeper Studio
December 18, 2022 - RDS is typically charged on a per-hour or per-second basis, depending on the chosen database engine and the size and configuration of the database instances. Redshift, on the other hand, is charged based on the amount of data stored and the ...
Medium
medium.com › @abylead › aws-database-overview-rds-vs-aurora-vs-redshift-vs-dynamodb-7eeebb61ca98
Amazon RDS vs Redshift vs DynamoDB Database
November 12, 2023 - RDS is a standardized service on its instance with seven optional SQL database engines and Aurora provides two of them. That’s just the thing for read-intensive enterprise apps. Aurora instances are organized in clusters and connected with an additional distributed storage cluster and a serverless option. All of this gives you higher global SQL performance and scalability also for modern global apps. Similar, Redshift data warehouse instances are also organized in clusters for very large data analytics such as Business Intelligence at moderate costs.
DZone
dzone.com › data engineering › databases › rds, redshift, dynamodb, and aurora – how do they compare?
RDS, Redshift, DynamoDB, and Aurora – How Do They Compare?
April 3, 2020 - Redshift is more expensive at its base rate and has additional pricing models for additional features. DynamoDB’s pricing is similar to RDS but reflects its differing functionality.
Just After Midnight
justaftermidnight247.com › insights › rds-redshift-dynamodb-and-aurora-how-do-aws-managed-databases-compare
RDS, Redshift, DynamoDB and Aurora - how do AWS’ managed databases compare? | Just After Midnight
January 23, 2026 - Redshift is more expensive at its base rate and has additional pricing models for additional features. DynamoDB’s pricing is similar to RDS but reflects its differing functionality.
Stack Overflow
stackoverflow.com › questions › 60507785 › reporting-aws-tools-rds-or-redshift
amazon web services - Reporting AWS Tools RDS or Redshift? - Stack Overflow
From a cost perspective, Amazon RDS might be a lower cost, but it really depends upon whether it has the required performance. If possible, try them both and do some comparisons. For Amazon RDS, indexing tables is important. For Amazon Redshift, selecting the best Distribution Key and Sort Key for each table is most important.
CloudThat
cloudthat.com › home › blogs › choosing between amazon rds and amazon redshift
Choosing Between Amazon RDS and Amazon Redshift
June 25, 2024 - Performance Requirements: Determine the performance benchmarks and latency tolerances of your application. While Amazon RDS is optimized for OLTP (Online Transaction Processing) workloads, Redshift excels in OLAP scenarios requiring complex analytics.
CloudThat
cloudthat.com › home › blogs › comparison between amazon rds and amazon redshift
Comparison between Amazon RDS and Amazon Redshift
June 25, 2024 - Amazon RDS is a managed relational database service that excels in transactional applications and guarantees data integrity, whereas Amazon Redshift is a fully managed data warehousing service that is optimized for analytical processing on sizable datasets. You can employ this comparison to help you pick the best solution for your data needs by learning more about their capabilities, use cases, scalability, pricing models, and other factors.
CloudZero
cloudzero.com › home › blog › a beginner’s guide to amazon rds pricing
Amazon RDS Pricing: A Complete Guide (2026)
April 15, 2026 - To achieve the best price-performance ratio, right-size your RDS instances using a tool like CloudZero Advisor. The Amazon RDS service provides managed relational (SQL) databases, while Amazon DynamoDB provides managed key-value and document databases (NoSQL). One major difference is that RDS does not use clusters or nodes, which RedShift relies on.
AWS
aws.amazon.com › blogs › architecture › exploring-data-transfer-costs-for-aws-managed-databases
Exploring Data Transfer Costs for AWS Managed Databases | AWS Architecture Blog
February 17, 2022 - When selecting managed database services in AWS, it’s important to understand how data transfer charges are calculated – whether it’s relational, key-value, document, in-memory, graph, time series, wide column, or ledger. This blog will outline the data transfer charges for several AWS ...