During high load (ie when many events are coming in), I notice that postgres load goes up very very fast. I had always notice that sentry does not maintain persistent postgres connection and I think this is the main reason postgres bottleneck is very low. Another indication of this postgres pattern is that, system cpu usage on postgres is relatively very very high (30%). On the pg hardware that normally get about 7000 insert/s, 200 insert/s saturates the sentry postgres. Any plan to change this in the future? I am using setry 8.9.0 with redis buffer. Do you think that having memcache will help? I looked into documentation on how to include memcache in the setup and it could not find it in the latest doc at https://docs.sentry.io/
You should use pgbouncer.