{"topic":{"slug":"postgres","name":"Postgres","article_count":3,"latest_published_at":"2026-10-01T12:00:00.000Z","url":"https://listedarticles.com/topics/postgres"},"articles":[{"slug":"planetscale-released-text-search-and-we-have-a-lot-to-say-part-i","title":"PlanetScale Released Text Search and We Have a Lot to Say (Part I)","subtitle":null,"summary":"Two BM25 optimizations and benchmark configuration changes inspired by PlanetScale's TIN benchmarks make ParadeDB's text search faster without changing its document identifiers.","content_type":"blog_post","language":"en","canonical_url":"https://www.paradedb.com/blog/opening-a-closed-tin","author":{"name":"Ming Ying","url":null,"person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"ParadeDB","url":"https://www.paradedb.com/","listing_slug":"paradedb","listing":{"slug":"paradedb","name":"ParadeDB","listing_type":"company","url":"https://listedstartups.com/companies/paradedb"}},"topics":[{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"},{"name":"Open Source","slug":"open-source","url":"https://listedarticles.com/topics/open-source"},{"name":"Postgres","slug":"postgres","url":"https://listedarticles.com/topics/postgres"}],"about_listings":[],"cover_image_url":"https://www.paradedb.com/blog/opening-a-closed-tin/images/opengraph-image.png","license":"all-rights-reserved","word_count":3188,"reading_minutes":14,"published_at":"2026-10-01T12:00:00.000Z","added_at":"2026-10-01T18:09:59.875Z","updated_at":"2026-10-01T18:09:59.875Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":false},"profile_url":"https://listedarticles.com/articles/planetscale-released-text-search-and-we-have-a-lot-to-say-part-i","markdown_url":"https://listedarticles.com/articles/planetscale-released-text-search-and-we-have-a-lot-to-say-part-i.md","example":false,"citation":"Ming Ying, ParadeDB. \"PlanetScale Released Text Search and We Have a Lot to Say (Part I).\" 1 Oct 2026. https://www.paradedb.com/blog/opening-a-closed-tin (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://www.paradedb.com/blog/opening-a-closed-tin"},"snippet":null,"score":null},{"slug":"postgres-select-distinct-does-not-scale","title":"Postgres SELECT DISTINCT Does Not Scale","subtitle":null,"summary":"DBOS explains why Postgres SELECT DISTINCT can get surprisingly expensive as datasets grow, what the planner is doing, and how they mitigated it in practice.","content_type":"blog_post","language":"en","canonical_url":"https://www.dbos.dev/blog/postgres-select-distinct-does-not-scale","author":{"name":"DBOS","url":"https://www.dbos.dev/","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"DBOS","url":"https://www.dbos.dev/","listing_slug":null,"listing":null},"topics":[{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"Postgres","slug":"postgres","url":"https://listedarticles.com/topics/postgres"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"},{"name":"Engineering","slug":"engineering","url":"https://listedarticles.com/topics/engineering"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":1068,"reading_minutes":5,"published_at":"2026-09-24T18:12:43.000Z","added_at":"2026-09-26T06:11:39.027Z","updated_at":"2026-09-26T06:11:39.027Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":true},"profile_url":"https://listedarticles.com/articles/postgres-select-distinct-does-not-scale","markdown_url":"https://listedarticles.com/articles/postgres-select-distinct-does-not-scale.md","example":false,"citation":"DBOS, DBOS. \"Postgres SELECT DISTINCT Does Not Scale.\" 24 Sept 2026. https://www.dbos.dev/blog/postgres-select-distinct-does-not-scale (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://www.dbos.dev/blog/postgres-select-distinct-does-not-scale"},"snippet":null,"score":null},{"slug":"700-mb-s-of-kafka-throughput-on-postgres","title":"700 MB/s of Kafka throughput, on Postgres","subtitle":null,"summary":"Profiling Kafgres (Kafka-compatible broker inside Postgres) from ~113 MB/s to ~700 MB/s via cached SPI plans, relaxed commits, separate topic disks, and WaitEventSet socket readiness.","content_type":"blog_post","language":"en","canonical_url":"https://rynr.dev/blog/700mbskafgres/","author":{"name":"rynr","url":"https://rynr.dev/","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"rynr.dev","url":"https://rynr.dev/","listing_slug":null,"listing":null},"topics":[{"name":"Postgres","slug":"postgres","url":"https://listedarticles.com/topics/postgres"},{"name":"Kafka","slug":"kafka","url":"https://listedarticles.com/topics/kafka"},{"name":"Engineering","slug":"engineering","url":"https://listedarticles.com/topics/engineering"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"},{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":1062,"reading_minutes":5,"published_at":"2026-09-23T00:00:00.000Z","added_at":"2026-09-25T06:19:17.385Z","updated_at":"2026-09-25T06:19:17.385Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":true},"profile_url":"https://listedarticles.com/articles/700-mb-s-of-kafka-throughput-on-postgres","markdown_url":"https://listedarticles.com/articles/700-mb-s-of-kafka-throughput-on-postgres.md","example":false,"citation":"rynr, rynr.dev. \"700 MB/s of Kafka throughput, on Postgres.\" 23 Sept 2026. https://rynr.dev/blog/700mbskafgres/ (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://rynr.dev/blog/700mbskafgres/"},"snippet":null,"score":null}],"total":3,"next_offset":null}