Postgres for a data warehouse?

[rupertlssmith]

Hi,

Has anyone any thoughts/experience on the suitability of Postgres for building a data warehouse?

It also has an open source implementation of columnar data stores, which may prove useful:

https://www.citusdata.com/blog/76-postgresql-columnar-store-for-analytics

Rupert

[rupertlssmith]

mmmm. quiet round here?

Just thought I'd add, Amazon Redshift is built on Postgres.

[ngalemmo]

So is Netezza.

It's a relational DBMS.  So yes, you can implement a data warehouse.  Vendors, such as IBM(Netezza) and Amazon, modify the code base to suit their implementation. How it performs is a matter of the particular implementation, of which there are many.

[ron.dunn]

I'm sorry I'm late to this conversation.

PostgreSQL is an excellent DBMS for a mid-scale data warehouse, so good that it is the primary development platform for our data warehouse automation product. We see excellent performance, particularly in loads, and love the fact that it runs on Windows and Linux (and OS X for our development work), and on-premise or cloud.

For scale and performance, PostgreSQL is highly compatible with Redshift, but also with Snowflake Elastic Data Warehouse, giving you scale up options if you outgrow an SMP solution.

If your company is nervous about open source licensing, or wants an additional level of enterprise support and tooling, the commercial variant from EnterpriseDB is an excellent choice. We recommend this to corporate customers.

If you have any specific questions about PostgreSQL you're welcome to message me, and I'll gladly share our experience.

[Sponsored content]