中文 English Français Русский Español العربية

Chris van Eijk: Deleting one tenant in PostgreSQL: cascade, batch or DROP

Planet PostgreSQL2026-10-01 08:000 views

Deleting one tenant from a shared PostgreSQL 17 database, measured: cascade, batches or dropping a partition; locks, batch size, disk space, what stays behind.

Source：https://postgr.es/p/9xj

My favorites

PreviousChris van Eijk: Unique per tenant in PostgreSQL: soft delete and RLS leaks NextHarness bought Augment’s coding agents. The best feature hasn’t shipped yet.

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

LlamaIndex Workflows and LangGraph represent the two dominant paradigms for orchestrating complex agentic swarms: pure e

0dev.to Programming

Rider and Databases: Lesser-Known IDE Features That Save Time

Most developers work with databases through dedicated tools: some prefer SQL Server Management Studio (SSMS), others go

0dev.to Database

KivaDB v2: What's Coming and How You Can Contribute

We're excited to announce that development for KivaDB v2 is officially underway! In this post, we'll share what we're pl

0dev.to Database

Your LLM cost log says $0.00. The invoice says $1,320.

You log what each LLM call costs, right next to the request, in a DECIMAL(10,2) column like every other amount of money

0dev.to Database

SQLite in Production: A Practical Setup with Litestream Backups

SQLite often gets dismissed as a toy database, which surprises the many useful applications quietly running on it. For a

0dev.to Database

The Scariest Part of "Skynet Mode" Is Your Own Unauthenticated Endpoint

Somebody finally caught an attack agent with its pants down, and the interesting part isn't the name. Symantec researche

0dev.to Security

Chris van Eijk: Deleting one tenant in PostgreSQL: cascade, batch or DROP

Related posts

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

Rider and Databases: Lesser-Known IDE Features That Save Time

KivaDB v2: What's Coming and How You Can Contribute

Your LLM cost log says $0.00. The invoice says $1,320.

SQLite in Production: A Practical Setup with Litestream Backups

The Scariest Part of "Skynet Mode" Is Your Own Unauthenticated Endpoint