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?
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?