© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•6mo ago•
4 replies
trunch

How to stop persisting old realtime messages?

I feel like there's probably a simple solution to this that I'm missing... but I'm currently hitting database size limits because all of my realtime messages are being persisted in tables like these:

  realtime.messages_2025_07_27,
  realtime.messages_2025_07_28,
  realtime.messages_2025_07_29,
  realtime.messages_2025_07_30,
  realtime.messages_2025_07_31
  realtime.messages_2025_07_27,
  realtime.messages_2025_07_28,
  realtime.messages_2025_07_29,
  realtime.messages_2025_07_30,
  realtime.messages_2025_07_31


What's the best way to NOT retain messages past some arbitrary amount of time (like a day)? I've tried setting up cron jobs for this but they all work temporarily and then eventually start failing.

What's the best way to handle this? I don't think I want to keep a history of realtime updates (maybe I'm missing something).
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Python realtime messages
SupabaseSSupabase / help-and-questions
3y ago
Deleted realtime.messages table
SupabaseSSupabase / help-and-questions
3mo ago
docker stop supabase-realtime
SupabaseSSupabase / help-and-questions
2mo ago
how to use realtime
SupabaseSSupabase / help-and-questions
4y ago