How stable is the Advanced Visibility in Postgres/SQL?

As far as “stability” goes, the feature itself is stable to use, would note one issue found in forum post here specific to MySQL.

For production environments recommendation is still to use Elasticsearch if possible for now. Using SQL based persistence for advanced visibility will also depend on db size you have available so would consider this when making a decision especially for large use cases.