Postgres transaction logs not cleaning up in CDC incremental mode sync to Snowflake

<@U05JWLXFT1S> We worked with AWS and Airbyte on this issue and determined the behavior is expected. Basically we are only syncing once a day and Airbyte doesn’t acknowledge the updated offset to Postgres until the next sync, so the WAL logs that we synced are not cleared from Postgres until the next day.

https://github.com/airbytehq/airbyte/issues/42917#issuecomment-2269694140