Search Articles — Sudonull

https://sudonull.com/postgresql-recovery-without-2-5-tb-backup

Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.

https://sudonull.com/clickhouse-why-columnar-dbms-accelerate-analytics-by-100-times

We explain using real benchmarks and a betting scheme: ClickHouse vs PostgreSQL and MySQL. Architecture, query examples, use cases. Read 5 minutes.

https://sudonull.com/postgresql-transactions-locks-isolation-levels-mvcc-vacuum

Deep dive into PostgreSQL transaction and locking mechanisms. Analysis of isolation levels (Read Committed, Repeatable Read, Serializable), MVCC, VACUUM, and methods for solving concurrency issues.

https://sudonull.com/postgresql-query-optimization-and-understanding-index-operations

Figure out why PostgreSQL ignores indexes. Detailed analysis of EXPLAIN ANALYZE, selectivity, correlation, and advanced index types to improve database performance.

https://sudonull.com/health-score-for-postgresql-health-monitoring

Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.

PostgreSQL: The world's most advanced open source database

https://www.postgresql.org/

1 day ago · The official site for PostgreSQL, the world's most advanced open source database

PostgreSQL: Downloads

https://www.postgresql.org/download/

PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself.

PostgreSQL - Wikipedia

https://en.wikipedia.org/wiki/PostgreSQL

PostgreSQL was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. [27][28] In 1996, the project was …

Download PostgreSQL (free) for Windows, macOS and Linux | Gizmodo

https://gizmodo.com/download/postgresql

May 14, 2026 · PostgreSQL is an open source, database system known for its reliability, feature set, and performance. It's a great choice if you're a developer building complex applications with data integrity.

PostgreSQL Tutorial - W3Schools

https://www.w3schools.com/postgresql/index.php

In this tutorial you get a step by step guide on how to install and create a PostgreSQL database. You will learn how to create a project where you can create, read, update, and delete data.

pgAdmin - PostgreSQL Tools

https://www.pgadmin.org/

Mar 16, 2026 · The most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

Download - pgAdmin

https://www.pgadmin.org/download/

The software is available in source and binary format from the PostgreSQL mirror network. Because compiling from source requires technical knowledge, we recommend installing binary packages …

Install PostgreSQL - W3Schools

https://www.w3schools.com/postgresql/postgresql_install.php

Download PostgreSQL To install PostgreSQL locally on your computer, visit the installer by EDB, and download the newest version compatible with your operating system.

EDB: Open-Source, Enterprise Postgres Database Management

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

PostgreSQL is the world's most advanced open source database and the fourth most popular database. In development for more than 20 years, PostgreSQL is managed by a well-organized and highly …

PostgreSQL Tutorial - GeeksforGeeks

https://www.geeksforgeeks.org/postgresql/postgresql-tutorial/

Jul 10, 2026 · PostgreSQL is a free and open-source database management system used to store, organize and manage data efficiently. It is one of the most popular databases because it is reliable, …