PostgreSQL
Indexes, the query planner, JSONB and other internals of the database most teams already run.
- PostgreSQL JSONB Internals and IndexingPostgreSQL's jsonb type stores JSON documents as parsed binary values rather than raw text, so reads and comparisons skip re-parsing at the cost of a bit more work on write.
- Bitmap Index Scan in PostgreSQL: How It Works and When It AppearsA bitmap index scan is a two-step PostgreSQL access method: it first walks one or more indexes to build an in-memory bitmap of candidate heap locations, then a bitmap heap scan reads only those table blocks, in physical order, and rechecks the condition.
- Advantages of PostgreSQLPostgreSQL's main advantages are strict standards compliance, ACID-safe transactions, and an extension system that turns one engine into a platform for relational, geospatial, document, time-series, and graph workloads.
- Constant Values in PostgreSQLA constant in PostgreSQL is a literal value written directly into SQL text, such as a number, a quoted string, or TRUE, rather than a value pulled from a column or variable.
- PL/pgSQL Internals: How PostgreSQL Compiles and Executes ProceduresPL/pgSQL is PostgreSQL's built-in procedural language.
- PostgreSQL Architecture: Processes, Memory, and WALPostgreSQL uses a multi-process architecture: a postmaster process forks one backend process per client connection, and all backends share a region of memory for caching and coordination.
- PostgreSQL's Indexes: How They Work and When to Use ThemA PostgreSQL index is a separate on-disk structure that lets the planner find rows without scanning the whole table.
- How the PostgreSQL Query Optimizer WorksPostgreSQL's query optimizer is the planner component that turns a parsed SQL statement into an execution plan by comparing the estimated cost of alternative scan methods, join orders, and join algorithms.
- Relcache in PostgreSQL: How the Relation Cache WorksRelcache is PostgreSQL's per-backend cache of relation descriptors, the parsed, in-memory representation of a table or index built from system catalog rows.
- What Is PostGIS?PostGIS is an open-source extension that turns PostgreSQL into a spatial database, adding geometry and geography data types, spatial indexes, and a large library of functions for storing, querying, and analyzing location data.
- What Is PostgreSQL?PostgreSQL is an open-source object-relational database management system that enforces ACID transactions, a strict and extensible type system, and standard SQL, while supporting JSON, arrays, and custom data types natively.
- SQL: The Technology That Never Left Is BackSQL did not return because it went away; it stayed the default interface for transactional and analytical data the entire time NoSQL was growing.
- SQL vs NoSQL: Comparative Advantages and DisadvantagesSQL (relational) databases store data in fixed-schema tables linked by keys and enforce strong, ACID-style consistency.
- Why Uber Moved From PostgreSQL to MySQLUber Engineering published a 2016 account of moving one core datastore off PostgreSQL and onto Schemaless, a sharding layer built on MySQL, citing MVCC-related index bloat, replication overhead, costly per-connection memory use, and painful major-version upgrades.
- How to Select DBMS SoftwareChoosing a DBMS means testing your actual read and write patterns against candidate engines, not comparing feature lists.
- 6 Things to Consider When Choosing an Open Source DatabaseChoosing an open source database means weighing more than features and installation cost.
- Database High Availability ExplainedDatabase high availability (HA) is the ability to keep a database serving reads and writes through a server, disk, or network failure, with minimal downtime and minimal data loss.