Feb 12 · 11 min read · Metadata SEO Title: JSONB Performance: Indexing and Query Optimization Guide Meta Description: Master JSONB indexing strategies and query optimization techniques in PostgreSQL. Learn GIN, GiST indexes, and performance patterns for production workload...
Join discussionOct 16, 2025 · 5 min read · Storing semi-structured JSON data directly in a relational database like PostgreSQL offers incredible flexibility. The native JSONB data type is key, as it stores JSON in an optimized, binary format that's highly efficient to index and query. This gu...
Join discussionJun 22, 2025 · 4 min read · ✍️ 작성하게 된 이유 프로젝트에서 데이터 값을 Json으로 저장해야하는 경우가 있었다. 해당 프로젝트에서 PostgreSQL을 사용했는데 이는 JSON 데이터를 저장하고 활용할 수 있는 기능을 제공한다. 특히 JSON과 JSONB라는 두 가지 데이터 타입이 존재하는데, 처음 보면 왜 두 개나 있는지, 언제를 선택해야 하는지, 어떤 차이가 있는지 혼란스럽다. 이번 글에서는 JSON과 JSONB의 차이점, 장단점, 선택 기준까지 하나하나 정리해보...
Join discussion
Sep 14, 2024 · 3 min read · While using Spring Boot with PostgreSQL, have you ever needed to retrieve or persist data to JSONB column? If your answer is yes, and you are visiting this journal entry, chances are high that you need help to solve the error when using JSONB column....
Join discussionJul 31, 2024 · 4 min read · Application Scenarios of JSONB PostgreSQL has two data types related to JSON: JSON and JSONB. This article introduces JSONB which is also recommended for you. Suppose that all records in a table have attributes attr1..attr10, but only some records ha...
Join discussion
Feb 14, 2024 · 2 min read · PostgreSQL, a robust open-source relational database management system, boasts powerful JSON support. JSON (JavaScript Object Notation) simplifies data storage, resembling key-value pairs, objects, and arrays. JSON's flexibility makes it a popular ch...
Join discussion
Feb 8, 2024 · 1 min read · Understanding the JSON and JSONB data types in PostgreSQL is essential for developers working with JSON data. This concise guide highlights their differences and practical applications. JSON and JSONB Data Types The JSON data type, available since Po...
Join discussion
Dec 22, 2022 · 6 min read · JSON is one of the most popular human-readable data formats. PostgreSQL allows you to store JSON data and perform queries on it thanks to the json and jsonb data types. The introduction of these JSON data types represented a game changing moment for ...
Join discussion
Dec 21, 2021 · 5 min read · Context Following my Purrsuit of optimization method a few days ago I noticed a very slow api on New Relic at , it was our one of the slowest due as per the time taken by the database transcations in it, with an avg response time of just above 3.5s a...
Join discussion
