I got a request from my application team that they want the before image of selective columns when any delete occurs in DB. They will use this information for some audit purposes. Also we have CDC configured between on-prem PostgreSQL and Aurora PostgreSQL and certain tables are very large in size and have heavy delete operations on them.
Please help me find a way to meet the app team's requirements without impacting CDC.