References 관련

• freeCodeCamp
• Github
• Microsoft
  • Azure
• Medium
• dev.to
• velog
• Substack
• Supabse
• Become Mastermind
• Haki Benita
• Jonathan Katz
• Peter Eisentraut
• Adriano Caloiaro
• Ben Burwell
• citusdata
• JONATHAN KATZ
• Crunchydata
• Airbyte
• pganalyze
• 채널톡
• Brane Dump
• ParadeDB - Postgres for Search and Analytics
• PeerDB
• Worth Doing Badly
• Taras Kloba
• Kviklet
• Xata
• GIS Developer
• pgvecto.rs
• Stormatics
• InfoQ
• Pinaraf's website
• CYBERTEC
• Val Town Blog
• tistory
• Ali Ramadhan
• oso
• Timescale Blog
• Postgres.AI
• pgDash - Comprehensive PostgreSQL Monitoring
• tembo
• Mattermost
• MLJAR Studio
• 비즈니스, 테크놀로지, 리더십 - CIO Korea
• Stormatics: Professional Services for PostgreSQL
• Crunchy Data: Postgres for Cloud, Kubernetes, or Enterprise
• Tembo: Goodbye Database Sprawl, Hello Postgres
• Aiven - Your Trusted Data & AI Platform
• Charsyam's Blog
• Postgres Monitoring, Database Optimization and more · pganalyze Blog
• Open Source Database Software Support & Services | Percona
• Logto: The better identity infrastructure for developers
• 테크놀로지 리더를 위한 글로벌 IT 뉴스 - ITWorld Korea
• Shepherd Insurance
• Maciej Walkowiak | Java & Spring Boot | Freelance Software Consultant
• Rapidapp Documentation & Blog
• Christophe Avonture
• drew's dev blog
• any blockers?
• Kendrick B Jung's Blog
• 프리랜서 1등 플랫폼: 이랜서 | 기업의 프로젝트 재의뢰율 98%

---

freeCodeCamp

Advanced Indexing Strategies in PostgreSQL

---

Indexing in PostgreSQL is a process that involves creating data structures that are optimized to efficiently search and retrieve data from tables. An index is a copy of a portion of a table, arranged in a way that enables PostgreSQL to quickly locate and retrieve rows that match a...

---

Github

• cpursley/postgresql_is_enough.md

---

Microsoft

Azure

• How to optimize performance when using pgvector on Azure Cosmos DB for PostgreSQL

---

Medium

• How we switched to Java 21 virtual threads and got a deadlock in TPC-C for PostgreSQL
• @fengruohang - Postgres is eating the database world
• 29cm / PostgreSQL Autovacuum 장애 대응기 (1)
• hnasr / PostgreSQL Process Architecture

---

dev.to

• yugabyte / Comparing SQL engines by CPU instructions for simple DML

---

velog

• @qkrtkdwns3410 / postgresql vs mysql 비교
• @jeong3320 / postgres backup(pgbackrest)

---

Substack

• @bawolf - Embeddings are a good starting point for the AI curious app developer

---

Supabse

• Elixir clustering using Postgres
• What's new in pgvector v0.7.0
• postgres.new: In-browser Postgres with an AI interface

---

Become Mastermind

• Understanding database Indexes in PostgreSQL

---

Haki Benita

• The Unexpected Find That Freed 20GB of Unused Index Space

---

Jonathan Katz

• PGVECTOR 0.5.0 FEATURE HIGHLIGHTS AND HOWTOS
• DISTRIBUTED QUERIES FOR PGVECTOR

---

Peter Eisentraut

• Grouping digits in SQL

---

Adriano Caloiaro

• Choose Postgres queue technology

---

Ben Burwell

• Transactions Are Not Locks

---

citusdata

• Making PostgreSQL tick: New features in pg_cron

---

JONATHAN KATZ

• THOUGHTS ON POSTGRESQL IN 2024

---

Crunchydata

• An Overview of Distributed PostgreSQL Architectures

---

Airbyte

• A Guide to Logical Replication and CDC in PostgreSQL

---

pganalyze

• Waiting for Postgres 17: Incremental base backups

---

채널톡

• @Transactional의 해로움

---

Brane Dump

• Why Certificate Lifecycle Automation Matters

---

ParadeDB - Postgres for Search and Analytics

• pg_analytics: Transforming Postgres into a Fast OLAP Database
• Putting DuckDB in Postgres to Query Iceberg
• Full Text Search over Postgres: Elasticsearch vs. Alternatives

---

PeerDB

• Moving a Billion Postgres Rows on a $100 Budget
• How can we make pg_dump and pg_restore 5 times faster?

---

Worth Doing Badly

• How a kids' novel inspired me to simulate a gene drive on 86 million genealogy profiles

---

Taras Kloba

• How to use PostgreSQL for (military) geoanalytics tasks

---

Kviklet

• Parsing the postgres protocol

---

Xata

• Introducing pgzx: create PostgreSQL extensions using Zig

---

GIS Developer

• PostgreSQL 삭제 (on CentOS)

---

pgvecto.rs

• My binary vector search is better than your FP32 vectors
• pgvector vs. pgvecto.rs in 2024: A Comprehensive Comparison for Vector Search in PostgreSQL

---

Stormatics

• PostgreSQL Internals Part 2: Understanding Page Structure

---

InfoQ

• Relational Data at the Edge: How Cloudflare Operates Distributed PostgreSQL Clusters

---

Pinaraf's website

• Look ma, I wrote a new JIT compiler for PostgreSQL

---

CYBERTEC

• RECOVERING DELETED DATA FROM POSTGRESQL TABLES

---

Val Town Blog

• Code Search is Hard

---

tistory

• puleugo / 푸르고
  • [PostgreSQL] 내가 enum을 쓰지 않는 이유
• jojoldu / 기억보단 기록을
  • [PostgreSQL] Nested Loop Join을 HashJoin으로 개선하기
  • [PostgreSQL] 단일 테이블 컬럼을 최대한 활용하기
• 1000sj / SJ CODE
  • Postgresql Architecture #1 Client - Server Architecture
  • Postgresql Architecture #1 Client - Server Architecture
• hyunki1019 / Louis.Kim 의 제 3막
  • [Postgresql] 에 대한 소개 - 1st study
  • [Postgresql-study] WAL (write ahead log)
• cori / 코딩하는 오리
  • 도커를 이용한 PostgreSQL (원격) <-> PostgreSQL (로컬) 연동
• moonsng / 코딩도서관
  • Postgresql 사용이유?

---

Ali Ramadhan

• Building a weather data warehouse part I: Loading a trillion rows of weather data into TimescaleDB

---

oso

• A Logic Language for Distributed SQL Queries

---

Timescale Blog

• How We Scaled PostgreSQL to 350 TB+ (With 10B New Records/Day)
• 13 Tips to Improve PostgreSQL Insert Performance
• PostgreSQL and Pgvector: Now Faster Than Pinecone, 75% Cheaper, and 100% Open Source
• Pgvector vs. Pinecone: Vector Database Performance and Cost Comparison

---

Postgres.AI

• Common DB schema change mistakes

---

pgDash - Comprehensive PostgreSQL Monitoring

• RAG With PostgreSQL

---

tembo

• Introducing pg_timeseries: Open-source time-series extension for PostgreSQL
• How to Get the Most out of Postgres Memory Settings

---

Mattermost

• Making a Postgres query 1,000 times faster

---

MLJAR Studio

• How to create Dashboard in Python from PostgreSQL

---

비즈니스, 테크놀로지, 리더십 - CIO Korea

• EDB, AI 특화 DB 관리 플랫폼 ‘포스트그레스AI’ 출시

---

Stormatics: Professional Services for PostgreSQL

• Setting Up a High Availability 3-Node PostgreSQL Cluster with Patroni on Ubuntu 24.04

---

Crunchy Data: Postgres for Cloud, Kubernetes, or Enterprise

• Data Encryption in Postgres: A Guidebook

---

Tembo: Goodbye Database Sprawl, Hello Postgres

• Vector Indexes in Postgres using pgvector: IVFFlat vs HNSW

---

Aiven - Your Trusted Data & AI Platform

• Speed up PostgreSQL® pgvector queries with indexes

---

Charsyam's Blog

• Instagram 에서 ID 샤딩하기

---

Postgres Monitoring, Database Optimization and more · pganalyze Blog

• GeoDjango and PostGIS in Django

---

Open Source Database Software Support & Services | Percona

• A Practical Guide to PostgreSQL Indexes

---

Logto: The better identity infrastructure for developers

• Mastering PostgreSQL JSONB type in one article

---

테크놀로지 리더를 위한 글로벌 IT 뉴스 - ITWorld Korea

• 구식 포스트그레SQL이 다시 유행하는 이유

---

Shepherd Insurance

• The Great Database Migration

---

Maciej Walkowiak | Java & Spring Boot | Freelance Software Consultant

• PostgreSQL and UUID as primary key

---

Rapidapp Documentation & Blog

• Building Devops AI Assistant with Langchain, Ollama, and PostgreSQL

---

Christophe Avonture

• Don't query your PostgreSQL db anymore, prefer PostgREST

---

drew's dev blog

• How Postgres stores data on disk – this one's a page turner

---

any blockers?

• Postgres as a search engine

---

Kendrick B Jung's Blog

• PostgreSQL의 Dead Tuple과 Vacuum

---

프리랜서 1등 플랫폼: 이랜서 | 기업의 프로젝트 재의뢰율 98%

• PostgreSQL의 차별화된 기능과 MySQL과의 차이

---