postgrest-docs icon indicating copy to clipboard operation
postgrest-docs copied to clipboard

question about scaling proccess/revise postgrest README

Open mananamenos opened this issue 5 years ago • 1 comments

Hi, in postgrest github readme you state: Being stateless to allow horizontal scaling. If there were a need to scale, what would be the differences comparing it with traditional haskell web server. In traditional server, i suppose you would need a load balancer first to scale horizontally. However in case of postgrest, you run ./postgrest which creates a process (like a server), which would need to some kind of load balancing also in case of too many requests, right? Or do you want to say that only db layer scaling would be needed (like using EnterpriseDb). Maybe someone could give me a high level picture of high level, basic execution steps in a scenario where scaling would be needed. Thanks

mananamenos avatar Jan 27 '20 18:01 mananamenos

The README needs revising, I'm also not sure about that sentence related to the Hasql library.

However postgrest is like another pg client, you can scale it horizontally. Though ideally it'd live on the same box as pg connected with a unix socket.

Or do you want to say that only db layer scaling would be needed (like using EnterpriseDb).

Not necessarily, replicas(pg + pgrst) could be added for read performance.

I'll move this to docs, I'll see about adding a section about scaling in the next version.

steve-chavez avatar Jan 29 '20 18:01 steve-chavez

I think the README is fine as it is in that regard.

wolfgangwalther avatar Feb 18 '24 13:02 wolfgangwalther