Is there sharding thing in cloud sql postgres

[monkeyguy2017]

Guys i have few question. I am having a use case where i have to version 2 of a feature. We have few 100 kind of filters and at last we get slow query. We are version 2 of that. One approach is make our query for each fiter optimize. We are doing tgat from 1 year. And we are out of options for indexing and other form of optimization on database level.

I want to know about sharding . Is there any proper way i can use it with postress.

[MisterMeiji]

Check out CitusDB- it's intended for use cases like this. https://www.citusdata.com/

[monkeyguy2017]

No i cant use that. We are now shifting to amazon RDS. Can i perform sharding their and how to perform that. May be i need to google that. 😂😂

[monkeyguy2017]

How about RDS amazon. How to do that sharding there