search

supabase / benchmarks-archive

Infrastucture benchmarks
https://supabase.com
MIT License
31 stars 4 forks source link

postgres: pgtune configs for m5a/t3a types and pgbench testing on separate machine #29

Closed steve-chavez closed 2 years ago

steve-chavez commented 2 years ago

Also move postgrest pgtune settings to config file

steve-chavez commented 2 years ago

Used those configs to get the pgbench numbers on https://github.com/supabase/benchmarks/issues/9#issuecomment-1112824794

steve-chavez commented 2 years ago

increasing the client size (typically, I'd want the machine driving the load to be at least as big as the target, to avoid any chance that we're bottlenecking on the client)

True. In fact this might already be happening because I'm now unable to get more TPS past m5a.8xlarge by increasing the number of clients.

Will follow up on this on a new PR.