[PostgreSQL] About
Data Type (데이터 형) 기본형: Integer, Numeric, String, Boolean 구조형: Date/Time, Array, Range / Multirange, UUID 문서형: JSON/JSONB, XML, Key-value(Hstore) 기하학: Point, Line, Circle, Polygon 맞춤형: Composite, Custom Types Data Integrity (데이터 무결성) UNIQUE, NOT NULL Primary Keys Foreign Keys Exclusion Constraints (제외 제약) Explicit(명시적) Locks, Advisory(권고) Locks Concurrency (동시성), Performance (성능) 인덱싱: B-tree, Multicolumn, Expressions, Partial 고급인덱싱: GiST, SP-Gist, KNN Gist, GIN BRIN, Covering indexes, Bloom filters Sophisticated(정교한) query planner / optimizer, index-only scans, multicolumn statistics(통계) Transactions, Nested(중첩된) Transactions (via savepoints) Multi-Version concurrency Control (MVCC) (다중버전 동시제어) Parallelization of read queries and building B-tree indexes (읽기 쿼리의 병렬화 및 B-tree 인덱스 구축) Table partitioning All transaction isolation levels defined in the SQL standard, including Serializable (직렬화 가능 및 모든 트랜잭션 격리 레벨이 SQL 표준에 정의됨) Just-in-time (JIT) compilation of expressions Reliability (안정성), D