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

Chris van Eijk: hstore vs jsonb performance in PostgreSQL, measured

Planet PostgreSQL2026-10-19 08:000 views

hstore against jsonb on a million flat documents in PostgreSQL 17 and 18, measured: storage, reads, updates, GIN indexes, and what hstore does to types.

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

My favorites

PreviousChris van Eijk: Supabase RLS: when (select auth.uid()) helps, measured NextEA Shutters BioWare, Creator of Mass Effect, Dragon Age, KOTOR and More

SOLID Principles Explained: 5 Essential Principles for Writing Clean, Maintainable Code

SOLID principles are a set of five fundamental object-oriented design principles that help developers build software tha

0dev.to Tutorial

How to Build a Professional Resume in 2026: Best Resume Formats, Templates, and ATS Tips

Creating a professional resume is one of the most important steps when looking for a new job. However, many job seekers

0dev.to Career

How to Explain Your Project in a Technical Interview

"Walk me through a project you worked on" is one of the most common questions in technical interviews. It is also where

0dev.to Career

Stop Calling It "Refactoring" When You Are Just Moving The Bugs Around

Let's talk about the ultimate corporate tech delusion: the quarterly "code cleanup" or what senior developers love to pr

0dev.to Career

PostgreSQL migrations that lock a busy table

Which schema changes in PostgreSQL block reads or writes on a live table, why each one does, and the safer sequence of s

0dev.to Testing

🧠 Do Prompt ao RAG: como fazer um LLM responder sem inventar (e sem processo do cliente)

E aí, dev que já viu uma IA inventar uma política de reembolso que não existe? Ou pior: prometer um recurso que o produt

0dev.to Java

Chris van Eijk: hstore vs jsonb performance in PostgreSQL, measured

Related posts

SOLID Principles Explained: 5 Essential Principles for Writing Clean, Maintainable Code

How to Build a Professional Resume in 2026: Best Resume Formats, Templates, and ATS Tips

How to Explain Your Project in a Technical Interview

Stop Calling It "Refactoring" When You Are Just Moving The Bugs Around

PostgreSQL migrations that lock a busy table

🧠 Do Prompt ao RAG: como fazer um LLM responder sem inventar (e sem processo do cliente)