One solution that is striking me is....
1. I'll create one background worker and will initialise DSA in it.
2. If there are any callbacks available for client open/close connections, i'll attach/detach to the DSA in those callbacks.
But i'm not sure there are such callbacks available. If such callbacks exists in postgres and you guys know please help me out with that.
Thanks & Best Regards,
- Mahi