December 27, 2021 at 12:00 am
Comments posted to this topic are about the item Amazon Redshift
December 27, 2021 at 5:30 am
Heh... one of the companies I do work for insisted that they wanted to move their heavy import, validation, and distribution system to Red Shift. I asked "Why"? They said because they didn't understand "Set Based" programming in SQL Server and that's what's making their current stuff slow.
BWAAAA-HAAAA-HAAAA!!! Am I the only one that sees the irony in that?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 27, 2021 at 12:52 pm
Redshift is based on an earlier version of Postgres. It was modified to be a columnar database, but it doesn't have many of nice features and functions that were added to Postgres since it was forked.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
December 27, 2021 at 1:04 pm
Redshift is based on an earlier version of Postgres. It was modified to be a columnar database, but it doesn't have many of nice features and functions that were added to Postgres since it was forked.
This is what got me to click 'Postgres compatible' This link to the Docs says:
"Amazon Redshift is based on PostgreSQL" (first sentence)
"Redshift is specifically designed for online analytic processing (OLAP) and business intelligence (BI) applications"
"PostgreSQL 9.x includes some features that are not supported in Amazon Redshift. In addition, there are important differences between Amazon Redshift SQL and PostgreSQL that you must be aware of. This section highlights the differences between Amazon Redshift and PostgreSQL and provides guidance for developing a data warehouse that takes full advantage of the Amazon Redshift SQL implementation."
Imo the marketing positioning of Redshift is somewhat confused. Disclaimer: I don't really know anything about Redshift and only a tiny bit of Postgres. The Docs suggest it's good for everything and then tell you to go build a Data Warehouse with it.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
December 27, 2021 at 3:12 pm
The question is irrelevant to the possible answers and to the explanation given. The question asks about the type of database, not what Amazon Redshift is.
According to Docs AWS "Data warehouse system architecture" is Amazon Redshift a relational database management system (RDBMS), so it is compatible with other RDBMS applications.
But their documentation also states that Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.
December 27, 2021 at 3:31 pm
Redshift is a data warehouse. That is all over the marketing and documentation. It is not available on-premises, nor is 100% compatible with PostgreSQL. I'll alter the question to note that.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply