Home

A look at why PostgreSQL skips indexes for small tables and how outdated statistics can slow down queries after big data inserts.

Lecture clarifying that PostgreSQL planner uses abstract cost units rather than milliseconds, with examples showing how costs reflect I/O and CPU work.

Explains why PostgreSQL falls back to a bitmap heap scan instead of an index-only scan, focusing on MVCC visibility and the visibility map.

An overview of transaction isolation levels, their behaviors, and practical strategies to manage concurrency in real-world database systems.

This note covers homomorphic encryption from a lecture, explaining what it is, how it lets us work with encrypted data, its pros and cons, and a demo showing it in action.

In this experiment, we test how large an SQL query can get before crashing a PostgreSQL database, using Node.js and Wireshark to monitor the process.

This lecture explains how to secure databases in REST API apps by using separate users with limited permissions for each route, avoiding risks like SQL injection.

This lecture explains how to set up a Postgres database with a secure TLS/SSL connection using Docker, connect to it with PgAdmin, and protect data in transit.