3 ms·
How well do foreign data wrappers work with Postgres's query planner? Does't the planner need to estimate the cardinality of results from each table? Are the Su
by spankalee 4y ago
How well do foreign data wrappers work with Postgres's query planner? Does't the planner need to estimate the cardinality of results from each table? Are the Supabase wrappers providing this info from the wrappers even though it might be hard to get from the data source?
Also, is the Firebase connector for Realtime Database or Firestore?
- burmecia 4y ago| How well do foreign data wrappers work with Postgres's query planner? You can provide table size estimation to Postgres's query planner in wrappers using `get_rel_size()` function, here is doc: https://docs.rs/supabase-wrappers/latest/supabase_wrappers/interface/trait.ForeignDataWrapper.html#method.get_rel_size https://docs.rs/supabase-wrappers/latest/supabase_wrappers/i... | Also, is the Firebase connector for Realtime Database or Firestore? It is for Firestore, Realtime Database is not supported yet.