{"topic":{"slug":"postgresql","name":"PostgreSQL","article_count":5,"latest_published_at":"2026-11-09T00:00:00.000Z","url":"https://listedarticles.com/topics/postgresql"},"articles":[{"slug":"json-vs-jsonb-in-postgresql-size-and-speed-measured","title":"json vs jsonb in PostgreSQL: size and speed, measured","subtitle":null,"summary":"json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN indexes, and what jsonb changes in your data.","content_type":"research","language":"en","canonical_url":"https://now-next.nl/en/insights/postgresql-json-vs-jsonb-measured/","author":{"name":"Chris van Eijk","url":null,"person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"Now-Next","url":"https://now-next.nl/","listing_slug":null,"listing":null},"topics":[{"name":"databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"postgresql","slug":"postgresql","url":"https://listedarticles.com/topics/postgresql"},{"name":"benchmarks","slug":"benchmarks","url":"https://listedarticles.com/topics/benchmarks"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":3132,"reading_minutes":14,"published_at":"2026-11-09T00:00:00.000Z","added_at":"2026-11-11T17:12:06.455Z","updated_at":"2026-11-11T17:12:06.455Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":true},"profile_url":"https://listedarticles.com/articles/json-vs-jsonb-in-postgresql-size-and-speed-measured","markdown_url":"https://listedarticles.com/articles/json-vs-jsonb-in-postgresql-size-and-speed-measured.md","example":false,"citation":"Chris van Eijk, Now-Next. \"json vs jsonb in PostgreSQL: size and speed, measured.\" 9 Nov 2026. https://now-next.nl/en/insights/postgresql-json-vs-jsonb-measured/ (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://now-next.nl/en/insights/postgresql-json-vs-jsonb-measured/"},"snippet":null,"score":null},{"slug":"postgres-19-is-late-and-its-ais-fault","title":"Postgres 19 is late, and it's AI's fault","subtitle":null,"summary":"PostgreSQL committer Robert Haas explains why PostgreSQL 19 will likely slip to November or later: LLM-driven code review and bug hunting surfaced an unusual volume of defects in new features, forcing reverts and fixes, and he argues every developer will now need to raise their game.","content_type":"blog_post","language":"en","canonical_url":"https://rhaas.blogspot.com/2026/10/postgres-19-is-late-and-its-ais-fault.html","author":{"name":"Robert Haas","url":null,"person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"Robert Haas (rhaas.blogspot.com)","url":"https://rhaas.blogspot.com/","listing_slug":null,"listing":null},"topics":[{"name":"postgresql","slug":"postgresql","url":"https://listedarticles.com/topics/postgresql"},{"name":"databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"ai","slug":"ai","url":"https://listedarticles.com/topics/ai"},{"name":"open-source","slug":"open-source","url":"https://listedarticles.com/topics/open-source"},{"name":"software-engineering","slug":"software-engineering","url":"https://listedarticles.com/topics/software-engineering"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":897,"reading_minutes":4,"published_at":"2026-10-30T15:53:00.000Z","added_at":"2026-11-02T02:13:38.033Z","updated_at":"2026-11-02T02:13:38.033Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":true},"profile_url":"https://listedarticles.com/articles/postgres-19-is-late-and-its-ais-fault","markdown_url":"https://listedarticles.com/articles/postgres-19-is-late-and-its-ais-fault.md","example":false,"citation":"Robert Haas, Robert Haas (rhaas.blogspot.com). \"Postgres 19 is late, and it's AI's fault.\" 30 Oct 2026. https://rhaas.blogspot.com/2026/10/postgres-19-is-late-and-its-ais-fault.html (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://rhaas.blogspot.com/2026/10/postgres-19-is-late-and-its-ais-fault.html"},"snippet":null,"score":null},{"slug":"how-tablesample-picks-rows","title":"How TABLESAMPLE picks rows","subtitle":null,"summary":"Radim Marek explains how PostgreSQL's TABLESAMPLE really samples: SYSTEM picks whole pages so rows come in bundles, BERNOULLI with REPEATABLE drifts after an UPDATE, and hashing a key gives a stable sample, plus when each approach fits.","content_type":"tutorial","language":"en","canonical_url":"https://boringsql.com/posts/tablesample/","author":{"name":"Radim Marek","url":null,"person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"boringSQL","url":"https://boringsql.com/","listing_slug":null,"listing":null},"topics":[{"name":"PostgreSQL","slug":"postgresql","url":"https://listedarticles.com/topics/postgresql"},{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"SQL","slug":"sql","url":"https://listedarticles.com/topics/sql"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":2718,"reading_minutes":12,"published_at":"2026-10-11T00:00:00.000Z","added_at":"2026-10-25T11:10:50.620Z","updated_at":"2026-10-25T11:10:50.620Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":true},"profile_url":"https://listedarticles.com/articles/how-tablesample-picks-rows","markdown_url":"https://listedarticles.com/articles/how-tablesample-picks-rows.md","example":false,"citation":"Radim Marek, boringSQL. \"How TABLESAMPLE picks rows.\" 11 Oct 2026. https://boringsql.com/posts/tablesample/ (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://boringsql.com/posts/tablesample/"},"snippet":null,"score":null},{"slug":"introducing-tin-full-text-search-for-postgres","title":"Introducing TIN: full-text search for Postgres","subtitle":null,"summary":"PlanetScale announces TIN (Text INdex), a GA full-text search extension for Postgres and Neki with boolean/phrase/span queries, fuzzy and regex matching, BM25 ranking, and transaction-correct updates—built to be fast while staying inside Postgres.","content_type":"blog_post","language":"en","canonical_url":"https://planetscale.com/blog/introducing-tin","author":{"name":"Eric Ridge, Patrick Reynolds","url":"https://planetscale.com/blog/author/eebbrr","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"PlanetScale","url":"https://planetscale.com/","listing_slug":"planetscale","listing":{"slug":"planetscale","name":"PlanetScale","listing_type":"company","url":"https://listedstartups.com/companies/planetscale"}},"topics":[{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"PostgreSQL","slug":"postgresql","url":"https://listedarticles.com/topics/postgresql"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"},{"name":"Engineering","slug":"engineering","url":"https://listedarticles.com/topics/engineering"},{"name":"Open Source","slug":"open-source","url":"https://listedarticles.com/topics/open-source"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":3349,"reading_minutes":15,"published_at":"2026-09-16T12:00:00.000Z","added_at":"2026-09-19T18:15:48.967Z","updated_at":"2026-09-19T18:15:48.967Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":false},"profile_url":"https://listedarticles.com/articles/introducing-tin-full-text-search-for-postgres","markdown_url":"https://listedarticles.com/articles/introducing-tin-full-text-search-for-postgres.md","example":false,"citation":"Eric Ridge, Patrick Reynolds, PlanetScale. \"Introducing TIN: full-text search for Postgres.\" 16 Sept 2026. https://planetscale.com/blog/introducing-tin (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://planetscale.com/blog/introducing-tin"},"snippet":null,"score":null},{"slug":"introducing-chdb-postgres-extension-high-performance-imports-from-cloud-storage","title":"Introducing chdb Postgres extension: High-performance imports from cloud storage","subtitle":null,"summary":"ClickHouse announces the chdb Postgres extension: fast imports and exports across cloud storage and formats, powered by the embedded ClickHouse engine and usable via COPY-style workflows.","content_type":"blog_post","language":"en","canonical_url":"https://clickhouse.com/blog/introducing-chdb-postgres","author":{"name":"David Wheeler","url":"https://clickhouse.com/blog","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"ClickHouse","url":"https://clickhouse.com/","listing_slug":null,"listing":null},"topics":[{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"PostgreSQL","slug":"postgresql","url":"https://listedarticles.com/topics/postgresql"},{"name":"Data Engineering","slug":"data-engineering","url":"https://listedarticles.com/topics/data-engineering"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"},{"name":"Open Source","slug":"open-source","url":"https://listedarticles.com/topics/open-source"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":1599,"reading_minutes":7,"published_at":"2026-09-08T12:00:00.000Z","added_at":"2026-09-19T18:16:03.665Z","updated_at":"2026-09-19T18:16:03.665Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":false},"profile_url":"https://listedarticles.com/articles/introducing-chdb-postgres-extension-high-performance-imports-from-cloud-storage","markdown_url":"https://listedarticles.com/articles/introducing-chdb-postgres-extension-high-performance-imports-from-cloud-storage.md","example":false,"citation":"David Wheeler, ClickHouse. \"Introducing chdb Postgres extension: High-performance imports from cloud storage.\" 8 Sept 2026. https://clickhouse.com/blog/introducing-chdb-postgres (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://clickhouse.com/blog/introducing-chdb-postgres"},"snippet":null,"score":null}],"total":5,"next_offset":null}