And PostgreSQL supports almost every data type that you can think of.Redshift supports a great list a data types: SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE PRECISION, BOOLEAN, CHAR, VARCHAR, DATE, TIMESTAMP, TIMESTAMPTZ.Therefore, Amazon Redshift is better suited for online analytic processing (OLAP) and business intelligence (BI) applications, which require complex queries against large datasets. Columnar storage not only improves query speed, but save on I/O operations, and can reduce storage size required for the same data sets. Or in other words, for those queries involving many rows and few columns, Redshift performs significantly faster, and vice versa. Perhaps the biggest difference is that Redshift is column-oriented storage whereas Postgres is row-oriented. PostgreSQL uses native C library, streaming API for large objects, ADO.NET, JDBC, ODBC.Redshift uses standard open-source PostgreSQL JDBC and ODBC drivers.Redshift is cloud-hosted while PostgreSQL is available on various platforms: FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows Connection Methods This post is going to point out some of them.

PostgreSQL is the most advanced open source database management system, developed and maintained by PostgreSQL Global Development Group.Įven though Amazon Redshift was built based on PostgreSQL 8.4, the two databases have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. Redshift is the large-scale data warehouse service for use with business intelligence tools, developed by Amazon based on PostgreSQL.

Tableplus redshift