My understanding of the documentation at Upgrade the Temporal Server | Temporal Documentation is that if you are using ES for advanced visibility there is no need to upgrade the Postgres SQL DB schema.
The example shows using the v96 schema for the default persistence store and the document states “if you’re upgrading PostgreSQL to v12 or later to enable advanced Visibility features with Temporal Server v1.20, upgrade your PostgreSQL version first, and then run temporal-sql-tool with the postgres12 plugin”
Are there any benefits from upgrading the Temporal default persistence store to v12? We are already running Temporal 1.22? Was the action to simply upgrade using the v96 schema the correct one?
Thanks.