I am syncing source database, size is around 115 GB (73 mil records). I am using incremental + deduped history with combination of Debezium on the source database. Both databases are PostgreSQL.
Currently I am getting into issue with the size. Destination db is about 600GB for now. Because I have tables with data in database 3 times. I have raw tables with all the data, then tables SCD and then the final tables. I thought that temporarily tables will be deleted, but they are there.
Just want to copy my source database into destination, so the size should be similar. What to do?