Hi,
we've got a problem with basic normalization after an incremental load on Postgres2Postgres sync (append incremental).
We're loading quite large tables, around 150GB, first sync lasts almost 24 hours and normalization takes a few hours of it. That's expected.
But now, every incremental load contains just hundreds of rows, EL is done within a minute, and normalization then freezes, not fininshing within a day!
Can anyone tell me, what is a problem? Does it operates with whole normalized 150GB table or what? Should I change some settings or what can I do?
Thanks.