Em sex., 11 de fev. de 2022 17:19, Bruce Momjian <bruce@momjian.us> escreveu:
On Fri, Feb 11, 2022 at 03:56:03PM -0300, Jean Baro wrote: > Hi there, > > Just out of curiosity, is there anything that we (as developers) can do on our > code to (all together): > > - Have maximum performance while running on a single PG 14.1 database (HA) > (Google Cloud SQL); > - Be prepared (if needed in the future) to migrate the database to a sharding > solution (FDW) once the microservice exceeds the capability of a single machine
Good question. I think it is generally agreed that sharding would involve using partitions that point to foreign tables on other servers using foreign data wrappers. I have a talk here about it: