Postgres for a data warehouse?

View previous topic View next topic Go down

Postgres for a data warehouse?

Post  rupertlssmith on Fri Aug 14, 2015 9:28 am

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

Posts : 4
Join date : 2015-08-14

View user profile

Back to top Go down

Re: Postgres for a data warehouse?

Post  rupertlssmith on Tue Aug 25, 2015 8:46 am

mmmm. quiet round here?

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

rupertlssmith

Posts : 4
Join date : 2015-08-14

View user profile

Back to top Go down

Re: Postgres for a data warehouse?

Post  ngalemmo on Tue Aug 25, 2015 2:09 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Postgres for a data warehouse?

Post  ron.dunn on Fri Oct 09, 2015 9:28 pm

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.

ron.dunn

Posts : 55
Join date : 2015-01-06
Location : Australia

View user profile http://ajilius.com

Back to top Go down

Re: Postgres for a data warehouse?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum