ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Learn when a jsonb_path_ops GIN index gives faster containment queries with less write‑induced bloat, and how to tune pending‑list limits and autovacuum for write‑heavy PostgreSQL workloads.
Learn how PostgreSQL’s JSONB expression indexes can cut nested JSON query times from seconds to milliseconds. A practical guide with examples, trade‑offs, and next‑step actions.
A decision guide for choosing PostgreSQL GIN indexes on JSONB columns: compare operator classes, see when partial indexes shrink storage, and learn how to validate index usage with EXPLAIN and pg_stat_user_indexes.
The goal is to read a PostgreSQL JSONB column through an AdonisJS Lucid model as a plain JavaScript object after fetch, and to write a plain object back on save without manual stringification in application code. Lucid does not document guaranteed automatic JSONB casting, and behavior may differ between AdonisJS 5 and Lucid in AdonisJS 6. The node-pg type pa
I am trying to speed up the querying of some json data stored inside a PostgreSQL database. I inherited an application that queries a PostgreSQL table called data with a field called value where value is blob of json of type jsonb . It is about 300 rows but takes 12 seconds to select this data from the 5 json elements. The json blobs are a bit large but the
adonisjs
json