Feat: Supports read and write separation in postgresql

[luckylhb90]

Self Checks

• [X] I have searched for existing issues search for existing issues, including closed ones.
• [X] I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
• [X] [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:）
• [X] Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing? Tell me about your story.

Because within our team, we've been heavily promoting the use of DIFY internally. One of the challenges is that single-machine postgresql can't handle the volume of requests. The postgresql is faulty for many times.

So we need to support postgresql's read-write separation feature. But I don't think that's enough to solve the problem completely. But at the moment, it seems that this may help to improve the current problem.

2. Additional context or comments

Further thoughts are: Database sharding and splitting, service decomposition , use mq, etc... These are all aspects that could be considered.

3. Can you help us with this feature?

• [ ] I am interested in contributing to this feature.