Tomasz Gintowt·Jul 6How I Check If a PostgreSQL Index Is DamagedLife is writing its own scenarios. Here is one of mine.
Tomasz Gintowt·Jun 16Same PostgreSQL. Different operational philosophy — DBA vs DBREA DBA and a DBRE both work with databases, but they work in very different ways.
Tomasz Gintowt·Jun 2PostgreSQL Pattern Matching: LIKE vs SIMILARWhen working with PostgreSQL, filtering text is a common task — whether you’re searching users, emails, product names, or logs. Two…A response icon1A response icon1
Tomasz Gintowt·May 25PostgreSQL Logical Replication: features, limitations, and corner casesLogical replication in PostgreSQL is a powerful feature that allows selective replication of database objects and data changes between…A response icon1A response icon1
Tomasz Gintowt·Apr 29If not pgBackRest, then what? Rethinking PostgreSQL Backups in 2026For years, pgBackRest has been one of the most trusted backup solutions in the PostgreSQL ecosystem. It powered countless production…
Tomasz Gintowt·Apr 23PostgreSQL Transactions: COMMIT, ROLLBACK and SAVEPOINTWhen you work with a database, you often run multiple queries that belong together. For example, moving money from one account to another.
Tomasz Gintowt·Apr 8How to expose data from PostgreSQL to BI and Data Analyst TeamsWhen working with databases in real-world systems, especially where reporting and analytics are involved, one common challenge appears: how…
Tomasz Gintowt·Mar 23PostgreSQL Replication: Comparing Methods and ModesReplication is a core feature of PostgreSQL that enables high availability, scalability, and data distribution across systems…A response icon1A response icon1
Tomasz Gintowt·Feb 3pg_export_snapshot: What it is and how to use itPostgreSQL is famous for its strong transactional guarantees, but sometimes you need multiple sessions to see exactly the same snapshot of…A response icon1A response icon1
Tomasz Gintowt·Dec 16, 2025PostgreSQL DROP COLUMN: It Doesn’t Remove the Column ImmediatelyWhen working with relational database schemas, you may assume that dropping a column physically removes it from the table’s storage. In…
