Tag: postgresql

All the articles with the tag "postgresql".

• Row-Level Security in PostgreSQL: Keep Tenant Data in the Database

  14 Aug, 2026

  A practical guide to PostgreSQL Row-Level Security (RLS): tenant isolation, policies, application identity, common pitfalls, and a production-ready setup.

• JSON vs JSONB in PostgreSQL

  13 Nov, 2025

  PostgreSQL offers both JSON and JSONB types for flexible schemas. Discover how JSONB binary format, TOAST compression, and GIN indexes make it the superior choice for querying, while JSON remains ideal for simple storage.

• High-Throughput Log Ingestion with TimescaleDB

  15 Sep, 2025

  Learn how TimescaleDB enables high-throughput log ingestion by automatically chunking data and why splitting tables improves performance for time-series workloads.