search

supabase / realtime

Broadcast, Presence, and Postgres Changes via WebSockets
https://supabase.com/realtime
Apache License 2.0
6.82k stars 315 forks source link

fix: Change policy queries to use id to be faster #1108

Closed filipecabaco closed 3 months ago

filipecabaco commented 3 months ago

What kind of change does this PR introduce?

To improve performance we're going to use id on the RLS policy verification and avoid "limit" and other unnecessary query elements.

vercel[bot] commented 3 months ago

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

1 Skipped Deployment | Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **realtime-demo** | ⬜️ Ignored ([Inspect](https://vercel.com/supabase/realtime-demo/Gc9dTC93FjzAdXditCWbiNeQVGC3)) | [Visit Preview](https://realtime-demo-git-fix-partition-messages-table-supabase.vercel.app) | | Jul 29, 2024 9:11pm |
kiwicopple commented 3 months ago

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

The release is available on GitHub release

Your semantic-release bot :package::rocket: