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

Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured

Planet PostgreSQL2026-11-09 06:300 views

json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN, and what it changes.

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

My favorites

PreviousThe Breville Black Friday sale includes up to AU$1,000 off espresso machines and other appliances — and TechRadar readers can save an extra 10%NextNvidia Board Launches Probe After Reports CEO Was Targeted by Chinese Spy

What broke when I tested pgvector vs Postgres full-text search vs Hybrid RRF on 30 tricky RAG chunks (and how I fixed it for $0)

Over the last few weeks, while working on a FastAPI and PostgreSQL RAG pipeline, I kept running into the same three head

0dev.to Database

Snowflake into PostgreSQL using Hydra ETL

Moving data out of Snowflake into PostgreSQL looks easy until the types come out wrong! That's the kind of silent change

0dev.to Database

SQLite error "no such column": usually missing quotes, plus 4 other causes

You want the visitors who went into the room called Vault, so you write: SELECT name FROM visitors WHERE room = Vault ;

0dev.to Database

How to Build a PostgreSQL Architecture with RLS and Local AI Workflows

Building full-stack web applications in 2026 often means balancing rapid prototyping with strict backend security. While

0dev.to WebDev

Nextcloud Helm chart: Bitnami subcharts and Kapitan

The Nextcloud Helm chart 9.4.1 packages Bitnami's PostgreSQL, MariaDB and Redis charts as optional subcharts, all switch

0dev.to DevOps

sqlmap in 15 Minutes: From First Request to Extracted Data in a Lab

This post is a hands-on introduction to sqlmap, a tool that automates the detection and exploitation of SQL injection. A

0dev.to

Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured

Related posts

What broke when I tested pgvector vs Postgres full-text search vs Hybrid RRF on 30 tricky RAG chunks (and how I fixed it for $0)

Snowflake into PostgreSQL using Hydra ETL

SQLite error "no such column": usually missing quotes, plus 4 other causes

How to Build a PostgreSQL Architecture with RLS and Local AI Workflows

Nextcloud Helm chart: Bitnami subcharts and Kapitan

sqlmap in 15 Minutes: From First Request to Extracted Data in a Lab