What's the best practice of Postgres sharding? - Mailing list pgsql-general

From Wang Xu
Subject What's the best practice of Postgres sharding?
Date
Msg-id 7DC83428-D605-4701-8721-14B3202C5F67@gu360.com
Whole thread Raw
List 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
applicationsthat 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


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?
Next
From: tutiluren@tutanota.com
Date:
Subject: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?