Greenplum use cases for OLTP?

393 views
Skip to first unread message

dmitry....@high5games.com

unread,
Sep 15, 2017, 2:28:16 PM9/15/17
to Greenplum Users
Hi board!

I appreciate if someone points me to use cases for GP database. I am looking for scalable, clustered database for pure OLTP workload: 80% UPDATEs, 10% INSERTs, 10% SELECTs
Is GP a good candidate for this? From what I read the use case for GP is really analytics, and DW type of workloads. Any links/white papers would be helpful. Thanks!

Ivan Novick

unread,
Sep 15, 2017, 9:07:21 PM9/15/17
to dmitry....@high5games.com, Greenplum Users
Mixed workload and very complex analytics environments with high concurrency: YES!

pure OLTP: no, its not appropriate.

Cheers,
Ivan

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.
To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.



--
Ivan Novick, Product Manager Pivotal Greenplum

Luis Macedo

unread,
Sep 17, 2017, 2:17:30 PM9/17/17
to Ivan Novick, Greenplum Users, dmitry....@high5games.com
Dmitry,

For OLTP, If you can go noSQL, you may want to take a look at Apache Geode which is in memory so your mostly update workload will benefit a lot.

If you are looking into a PostgreSQL based solution, you can use the sharding technique on top of PG, but then you will manage distribution of workload on your app code. There is another variant for PG that focuses on OLTP and is distributed but I can't seam to recall...


--- Sent from my Google Pixel

Keaton Adams

unread,
Sep 17, 2017, 4:20:43 PM9/17/17
to Greenplum Users
Agreed that Greenplum DB is not a good architectural solution for your specific use case.

If you need to stay SQL-relational / traditional OLTP for your work, then have a look at PostgreSQL Bi-Directional Replication for distributed, scalable read/write operations:


The other option to consider for distributed, fault-tolerant transactional work is Cassandra:

Vishal Patel

unread,
Sep 17, 2017, 6:54:20 PM9/17/17
to Greenplum Users, Keaton Adams
One other option for distributed OLTP is Citus data. I would take a look at that as well, works on top of the latest Postgres release.

--

You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

Rupesh Choudhary

unread,
Oct 20, 2017, 11:16:49 AM10/20/17
to Vishal Patel, Greenplum Users, Keaton Adams
Another option would be to go for EDB's Postgres Advanced server along with tools like PEM , failover manager . 

Very much inline with Oracle and easy to migrate without having to re-write stored procs and functions .




On 18 September 2017 at 04:23, Vishal Patel <vishp...@gmail.com> wrote:
One other option for distributed OLTP is Citus data. I would take a look at that as well, works on top of the latest Postgres release.


On Sep 17, 2017, 1:20 PM -0700, Keaton Adams <kad...@pivotal.io>, wrote:
Agreed that Greenplum DB is not a good architectural solution for your specific use case.

If you need to stay SQL-relational / traditional OLTP for your work, then have a look at PostgreSQL Bi-Directional Replication for distributed, scalable read/write operations:


The other option to consider for distributed, fault-tolerant transactional work is Cassandra:





On Friday, September 15, 2017 at 12:28:16 PM UTC-6, dmitry....@high5games.com wrote:
Hi board!

I appreciate if someone points me to use cases for GP database. I am looking for scalable, clustered database for pure OLTP workload: 80% UPDATEs, 10% INSERTs, 10% SELECTs
Is GP a good candidate for this? From what I read the use case for GP is really analytics, and DW type of workloads. Any links/white papers would be helpful. Thanks!

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.
Reply all
Reply to author
Forward
0 new messages