database:postgresql

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- database:postgresql [2016/01/01 20:27]
kwon37xi
+++ database:postgresql [2024/02/08 10:29] (현재)
kwon37xi
@@ 줄 1: / 줄 1: @@
-====== PostgreSQL ======
+====== 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)]]
 ===== 참고 =====
@@ 줄 7: / 줄 15: @@
   * [[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]]

database/postgresql.1451649426.txt.gz · 마지막으로 수정됨: 2016/01/01 20:27 저자 kwon37xi