By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

PostgreSQL cluster set up

P: 1
We are looking to migrate our DB from oracle to postgresql DB. Current oracle setup is as follows:

1. OLTP application with 95% writes
2. Production is on a Oracle RAC cluster
3. Most of the tables are partitioned

What we are curreltly exploring is postgresXL cluster (equivalent of our Oracle RAC, so that we can create a 3 data node cluster with a coordinator and global transaction manager).
Our idea is, we will scale this up as required if the POC is a success.

In postgres XL cluster we are creating child tables for each partition and distributing the data in the 3 data nodes equally. There are triggers which will put the data in child tables (equivalent to oracle partitions)

Are we on the right track? Is there an alternate solution we can try for our requirement? has anyone tried this before?
Dec 15 '16 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.