DBDatabases
Explore how indexes, transactions, joins, and isolation keep data fast and consistent. — 27 entries
Database index데이터베이스 인덱스
A sorted lookup structure narrows the search for rows instead of scanning the whole table.
Relational model관계형 모델
Keys connect table rows so a query can combine the columns it needs.
Primary key기본 키
A primary key uniquely identifies each row in a table.
Foreign key외래 키
The database checks that a child row points to an existing parent row.
Database normalization데이터 정규화
Move repeated facts into related tables to reduce inconsistent updates.
Query execution plan쿼리 실행 계획
A plan shows how the database scans, joins, and sorts to answer a query.
ACID transactionsACID 트랜잭션
A transaction groups several database changes into one success or failure unit.
Transaction isolation levels트랜잭션 격리 수준
Isolation levels determine when concurrent transactions can see each other’s changes.
Multi-version concurrency control다중 버전 동시성 제어
Multiple row versions let a reader keep its snapshot while a writer creates a newer version.
Database replication데이터베이스 복제
Changes from a primary are copied to replicas for reads and recovery.
Database sharding데이터베이스 샤딩
A shard key distributes rows across multiple databases.
Change data capture변경 데이터 캡처
Changes in a database log become events delivered to other systems.
Vector similarity search벡터 유사도 검색
Find stored vectors closest to a query vector by a distance measure.
PostgreSQL asynchronous I/OPostgreSQL 비동기 I/O
PostgreSQL 18 introduced an AIO subsystem that can overlap storage reads.
PostgreSQL index skip scanPostgreSQL 인덱스 스킵 스캔
PostgreSQL 18 can search a multicolumn B-tree using a later column without a leading equality condition.
Write-ahead log선행 기록 로그
Record a change durably before modifying its data page.
PostgreSQL UUIDv7 generationPostgreSQL UUIDv7 생성
PostgreSQL 18 uuidv7() generates timestamp-ordered UUIDs.
Virtual generated columns가상 생성 열
PostgreSQL 18 supports generated columns computed when read.
Temporal constraints시간 범위 제약
PostgreSQL 18 can reject overlapping validity periods through key constraints.
Wait for LSN복제본 쓰기 반영 대기
PostgreSQL 19 beta WAIT FOR LSN waits for a replica to replay a target log position.
SQL property graph queriesSQL 속성 그래프 질의
PostgreSQL 19 beta supports SQL/PGQ path queries over relationships stored in tables.
PostgreSQL plan advicePostgreSQL 실행 계획 조언
The PostgreSQL 19 beta pg_plan_advice extension can stabilize or influence planner choices.
Materialized view구체화 뷰
Store a query result for fast reads, then refresh it to reflect source changes.
PostgreSQL concurrent repackPostgreSQL 병행 리팩
PostgreSQL 19 beta REPACK CONCURRENTLY reorganizes a table without blocking reads and writes.
PostgreSQL I/O worker autoscalingPostgreSQL I/O 워커 자동 조절
PostgreSQL 19 beta scales worker-based asynchronous I/O within configured worker limits.
Database connection poolingDB 연결 풀링
Requests borrow and return a small set of reusable database connections.
Table partitioning테이블 파티셔닝
Split a large table by range or another key so queries can read only matching partitions.