mercredi 7 janvier 2015

Postgres 9.4 jsonb datatype


I am creating a database using PostgreSQL 9.4 which would have 3 tables suppose A, B ,C with columns of 'jsonb' datatypes.


-I want to replicate table A into table B after inserting data in A, also Simultaneously pull specific json objects from B to put them in table C ?


-Will my system get affected if I have to do it for over 1 million records which will be upgrading continuously?



  • I would like to know if the continuous updation of system would affect my systems performance?


Thanks





Aucun commentaire:

Enregistrer un commentaire