4 ms·
I always wonder if postgrest works well after growing quite a bit. I really should google the largest companies using it.
by jjallen 2y ago
I always wonder if postgrest works well after growing quite a bit. I really should google the largest companies using it.
- feverzsj 2y agoIn my experience, without careful tunning, postgres performance starts dropping significantly around 10 million rows.
- szundi 2y agoWe have billions of rows with clustering on one instance, perfect, half a rack almost.
- natmaka 2y agoWithout any consideration for I/O? In my experience performance is often directly related to the ratio (total RAM available to Postgresql, shared buffer and buffercache included / total size of tables and indices ), save any weird usage pattern.
- boomskats 2y agoCould you tell us a bit more about your experience?
- boomskats 2y agoJust check out who the key project maintainers are, and then look at who they're employed by. You'll probably recognize the companies. If you don't have schema cache reloading enabled (i.e. you're running it in prod), you can linearly scale postgrest instances pretty much infinitely without impact to the db. Each new instance just costs you a handful of connections and a small amount of memory.
- cpursley 2y agoCheck out supabase, they're all in on postgrest.