====== PostgreSQL pgsql ====== * [[http://www.postgresql.org/|PostgresQL]] * [[https://www.crunchydata.com/developers/tutorials|PostgreSQL Playgraound]] * [[http://opm.io/|Open PostgreSQL Monitoring]] * [[https://github.com/zalando/patroni|zalando/patroni: A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes]] ===== Hypertable Partitioning ===== * [[https://www.timescale.com/blog/is-postgres-partitioning-really-that-hard-introducing-hypertables/|Is Postgres Partitioning Really That Hard? An Introduction To Hypertables]] ===== Memoize ===== * [[https://jojoldu.tistory.com/700|PostgreSQL14 Memoize 성능 비교 (feat. 13 vs 14 Nested Loop)]] ===== 참고 ===== * [[http://helloworld.naver.com/helloworld/227936|hello world » 한눈에 살펴보는 PostgreSQL]] * [[https://vimeo.com/43536445|Vimeo Rob Conery - Five Things You Didn't Know About PostGresSQL]] * [[http://www.postgresqltutorial.com/|PostgresQL Tutorial]] * [[https://dzone.com/articles/postgresql-foreign-data-wrappers|PostgreSQL Foreign Data Wrappers]] * [[http://heap.engineering/running-10-million-postgresql-indexes-in-production/|Running 10 Million PostgreSQL Indexes In Production (And Counting)]] * [[https://pgdash.io/blog/postgres-12-generated-columns.html|New In PostgreSQL 12: Generated Columns - pgDash]] * [[https://techblog.woowahan.com/6550/|Aurora MySQL vs Aurora PostgreSQL | 우아한형제들 기술블로그]] * [[https://blog.crunchydata.com/blog/five-tips-for-a-healthier-postgres-database-in-the-new-year|Five Tips For a Healthier Postgres Database in the New Year]] * [[https://jojoldu.tistory.com/630|PostgreSQL (Aurora) 10 vs 11 버전 성능 비교]] : 12버전 이상을 사용해야 Covering Index 가 제대로 작동함. * [[https://blog.crunchydata.com/blog/five-tips-for-a-healthier-postgres-database-in-the-new-year|Five Tips For a Healthier Postgres Database in the New Year]] * [[https://blog.jooq.org/postgresql-14s-enable_memoize-for-improved-performance-of-nested-loop-joins/|PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins – Java, SQL and jOOQ.]] * [[https://www.timescale.com/blog/database-scaling-postgresql-caching-explained/|Database Scaling: PostgreSQL Caching Explained]] * [[https://www.timescale.com/blog/postgresql-performance-tuning-part-i-how-to-size-your-database/|PostgreSQL Performance Tuning: How to Size Your Database]] 계속 이어지고 있음. * [[https://www.amazingcto.com/postgres-for-everything/|Just Use Postgres for Everything | Amazing CTO]] * [[https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb|Postgres is Enough]]