While working on Airflow 2.1 version, we were connecting to Redshift serverless using the Postgres provider, but we have migrated to Airflow 2.8.1 and now have apache-airflow-providers-amazon 8.16.0, which provides Redshift connectivity. The question is, would we see any performance benefit or other advantage when we switch to the Redshift connection type?

While working on Airflow 2.1 version, we were connecting to Redshift serverless using the Postgres provider, but we have migrated to Airflow 2.8.1 and now have apache-airflow-providers-amazon 8.16.0, which provides Redshift connectivity. The question is, would we see any performance benefit or other advantage when we switch to the Redshift connection type?