Table size and full text search performance

Hello, I am using supabase and want to implement full text search.

I want to store 2 different types of recipes:
  1. Searchable recipes (recipes that are official, checked, correct values).
  2. non searchable recipes (copies of other recipes, non verified or user generated)
Should I have 2 different tables for these two groups or put everything into one table and have a column searchable?

Let's say if I only have 300 searchable recipes and 5 million non searchable, would that impact performance in any way?
Was this page helpful?