PostgreSQL

Guides/tips/...etc

• github.com/blackdesert575/postgresql-101
• TimescaleDB:
  • A time-series database for high-performance real-time analytics packaged as a Postgres extension
  • github.com/timescale/timescaledb
• repmgr
  • repmgr is an open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers.
  • www.repmgr.org
• High Availability
  • patroni
    • A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
  • github.com/patroni/patroni
  • postgres-operator
    • Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
    • github.com/CrunchyData/postgres-operator
• PostgreSQL 18
  • www.postgresql.org/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
  • www.postgresql.org/docs/18/sql-keywords-appendix.html
• wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
• cloudnative-pg/cloudnative-pg/blob/main/docs/src/quickstart
  • This section guides you through testing a PostgreSQL cluster on your local machine by deploying CloudNativePG on a local Kubernetes cluster using either Kind or Minikube.
• 正規化探討
• neon
  • Neon is a serverless Postgres platform designed to help you build reliable and scalable applications faster. We separate compute and storage to offer modern developer features such as autoscaling, branching, instant restore, and more.
  • neon.com/docs/introduction