| From: | Wang Xu <wangxu(at)gu360(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | What's the best practice of Postgres sharding? |
| Date: | 2020-09-25 02:57:08 |
| Message-ID: | 7DC83428-D605-4701-8721-14B3202C5F67@gu360.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
We have one master/slave nodes running already, it works very well until now we need more business data to be stored.
But our running machine almost reached the read/write limit (1600 ops/s).
So what I am thinking is that I add more machines to store the new business data.But I don’t want to change my applications that query the data.
In short I want one single query entry, multiple machines to do data-persistence job.
What’s the best practice in this situation?
Thanks a lot,
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tutiluren | 2020-09-25 04:41:45 | Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? |
| Previous Message | Bruce Momjian | 2020-09-24 23:20:01 | Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? |