Relational database
The world's most advanced open-source relational database.
An extensible, standards-compliant RDBMS known for MVCC, rich data types (JSONB, arrays, ranges), powerful indexing (B-tree, GIN, GiST, BRIN) and a huge extension ecosystem.
PostgreSQLIntermediateMVCC means Postgres doesn't store a row count. Make exact counts cheaper, get instant estimates from the planner, and keep exact counters when you really need them.
#internals#mvcc#performance
Every UPDATE in PostgreSQL leaves a dead row behind. Here's how MVCC works under the hood, what VACUUM cleans up, and how to keep autovacuum ahead of your workload.
#concurrency#internals#maintenance
PostgreSQLIntermediateLearn to read PostgreSQL query plans node by node — estimates vs. actuals, loops, buffers — and turn them into index and query fixes.
#execution-plans#indexing#performance
PostgreSQLBeginnerPostgreSQL Global Development Group has announced the first release candidate of version 10 of its popular database PostgreSQL. The PostgreSQL 10 RC1 is now available for download.
#news
PostgreSQLBeginnerThe new version of open source ADO.NET Data Provider for PostgreSQL, Npgsql 3.2 is now available on nuget.org.
#news
PostgreSQLBeginnerIn this article you will learn how to install PostgreSQL.
#installation
PostgreSQLBeginnerIn this article you will learn about locks in PostgreSQL. PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance.
