PostgREST: REST API for any Postgres database

Re:PostgREST: REST API for any Postgres database by kiwicopple on Saturday November 21, 2020 @09:08PM (#25174299)

Hey, can you elaborate more on how you were using it and where it was failing? I'm genuinely curious as we use it at Supabase.

I assume you were using it with high throughput? We are benchmarking it at around 2000 request/s now [1], and finding it's better to scale it horizontally rather than vertically.

> process millions of heavy computing requests

Was this reads from the database? Was the compute happening inside a Postgres function/view?

[1] Benchmarks https://github.com/supabase/benchmarks/issues/2

[ Parent | on HN ]

Re:PostgREST: REST API for any Postgres database by pojzon on Sunday November 22, 2020 @05:07AM (#25176288)

Issue was with authenticating the requests. Pgcrypt was too much together with geospatial operations. No database instance could handle that - or it was so expensive it was not worth it.

[ Parent | on HN ]

Re:PostgREST: REST API for any Postgres database by kiwicopple on Sunday November 22, 2020 @05:23AM (#25176362)

Got it, good to know. So you moved all the geospatial operations out - what did you use? I want to make sure we can support enterprise later, even for these workloads.

[ Parent | on HN ]

Re:PostgREST: REST API for any Postgres database by pojzon on Sunday November 22, 2020 @07:49PM (#25182487)

Uh, We moved away from postgrest and went back to regular db + rest-service architecture.

The project (postgrest) has too many disadventages at that scale for us.

[ Parent | on HN ]