fix: Janitor set to use ETS to reduce load on Database

supabase / realtime

Broadcast, Presence, and Postgres Changes via WebSockets

https://supabase.com/realtime

Apache License 2.0

6.83k stars 315 forks source link

fix: Janitor set to use ETS to reduce load on Database #1201

Closed filipecabaco closed 1 week ago

filipecabaco commented 1 week ago

What kind of change does this PR introduce?

Current implementation was using a more complex query that would load RDS too much. This approach focuses on using ETS and it will determine which databases with the following flow:

On Connect, tenant will be registered in ETS as active with {tenant.external_id, DateTime.utc_now()}
Janitor periodically will fetch the ETS entries, chunk them and run a cleanup
On each tenant cleanup, we will untrack the user by deleting their entry from ETS

vercel[bot] commented 1 week ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

1 Skipped Deployment

kiwicopple commented 1 week ago

:tada: This PR is included in version 2.33.29 :tada:

The release is available on GitHub release

Your semantic-release bot :package::rocket: