This article covers scaling advices for PostgreSQL and explains, why it may be a good idea to keep it simple on the database side.
https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/
ENBlogServicesPostgreSQL designDatabase architectureDatabase modelingPostgreSQL migrationMigration from OracleMigrating from MySQL / MariaDBCYBERTEC MigratorPostgreSQL administrationPostgreSQL disaster and data recoveryPerformance TuningRemote DBAPerformance and scalabilityAutomation with kubernetesPostgreSQL consultingPostgreSQL developmentPostgreSQL clustering and HAClustering and failoverHigh availability with PatroniPoint-In-Time-RecoverySynchronous and asynchronous replicationScaling with PL/ProxyCYBERTEC Partner NetworkSupportStandard PostgreSQL SupportProduct Support9/5 Basic Support24/7 Basic Support24/7 Enterprise SupportAdvanced PostgreSQL Support9/5 Remote DBA24/7 Remote DBA9/5 Dedicated DBA24/7 Cloud-based SupportSupport for Reseller3rd Level SupportCYBERTEC Partner NetworkProductsOur ProductsCYPEX – Build Apps & FormsCYBERTEC PostgreSQL Enterprise EditionCYBERTEC MigratorScalefield – Private PostgreSQL CloudPostgreSQL Transparent Data EncryptionData Masking for PostgreSQLPL/pgSQL_sec – Fully encrypted stored proceduresPostgreSQL Tools & Extensionspg_timetable – Advanced Job Schedulingpg_show_plans – Monitoring Execution Planspgwatch – PostgreSQL Monitoring Toolpg_squeeze – Shrinks TablesWalbouncer – Enterprise Grade Partial ReplicationPGConfigurator – Visual PostgreSQL Configurationora_migratorAssessment PackagesData Science Assessment PackageStart-Up Assessment PackageSpatial Data Assessment PackageCYBERTEC Partner NetworkTrainingCourse CatalogueOnline TrainingCustomized TrainingPostgreSQLAdvantages of PostgreSQLPostgreSQL BooksSolutions – Who uses PostgreSQLPostgreSQL for StartupsPostgreSQL for governments and public servicesLonglife solutionsBusiness CasesFraud DetectionPostgreSQL for biotech and scientific applicationsData ScienceData Science OverviewMachine LearningBig Data AnalyticsContactpast and current state of distributed MySQL architecturessee hereanother good linkpretty detailed overview here