--- title: Postgres 19 REPACK lands with caveats, Databricks... description: Postgres 19 beta is generating real discussion around REPACK, the new built-in command for online bloat reclamation — but fillfactor interaction is a genuine... canonical: https://daily.dev/posts/postgres-19-repack-lands-with-caveats-databricks-acquires-electric-for-neon-j9ivxorpq twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Postgres 19 REPACK lands with caveats, Databricks acquires Electric for Neon | daily.dev og:description: Postgres 19 beta is generating real discussion around REPACK, the new built-in command for online bloat reclamation — but fillfactor interaction is a genuine... og:url: https://daily.dev/posts/postgres-19-repack-lands-with-caveats-databricks-acquires-electric-for-neon-j9ivxorpq og:image: https://api.daily.dev/og/posts/j9IvxoRPQ.png og:image:alt: Postgres 19 REPACK lands with caveats, Databricks acquires Electric for Neon og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Postgres 19 REPACK lands with caveats, Databricks acquires Electric for Neon **[Databases Digest](https://daily.dev/sources/databases_digest)** · 5 min read · 0 upvotes · 0 comments ## Summary Postgres 19 beta is generating real discussion around REPACK, the new built-in command for online bloat reclamation — but fillfactor interaction is a genuine gotcha worth reading before you touch it in production. Databricks acquired Electric, folding PGlite and the Electric sync engine into Neon. Temporal Cloud's ClickHouse migration cut billing store costs 70% and bought three to five years of runway. pg_clickhouse v0.10 pushes a correlated subquery from 32.7 seconds to 37 milliseconds. ## Content **TLDR:** Postgres 19 beta is generating real discussion around REPACK, the new built-in command for online bloat reclamation — but fillfactor interaction is a genuine gotcha worth reading before you touch it in production. Databricks acquired Electric, folding PGlite and the Electric sync engine into Neon. Temporal Cloud's ClickHouse migration cut billing store costs 70% and bought three to five years of runway. pg_clickhouse v0.10 pushes a correlated subquery from 32.7 seconds to 37 milliseconds. --- ## Postgres 19 REPACK: native bloat reclamation, but fillfactor interaction is a real trap Postgres 19 beta ships REPACK CONCURRENTLY, a built-in alternative to VACUUM FULL (which locks) and the pg_repack extension (which requires setup). The community excitement is understandable — table bloat has always been painful. Franck Pachot's warning is specific though: get your fillfactor wrong and you're not solving bloat, you're relocating it. Beyond REPACK, the release adds SQL/PGQ for native graph traversal over existing tables, ON CONFLICT DO SELECT for true atomic get-or-create, GROUP BY ALL, and COPY TO JSON. JIT is now off by default, which will quietly improve a lot of workloads. Beta 2 is out now; final release expected September or October. [Read more](https://daily.dev/posts/V4FjlmUdD) ## Databricks acquires Electric, PGlite and sync engine join Neon Databricks acquired Electric — the team behind PGlite and the Electric sync engine — and folded them into Neon, the serverless Postgres company Databricks picked up earlier this year. The motivation is agentic workload patterns: on Lakebase, agents create roughly four times more databases than human users, average compute lives under 10 seconds, and some projects run over 500 branch iterations. PGlite, a full Postgres compiled to WASM, fits that disposable-ephemeral pattern well. Electric Cloud (the hosted service) is shutting down — existing users need to self-host or migrate. All open-source work stays open source. [Read more](https://daily.dev/posts/ZCnXrWul4) ## Temporal Cloud migrated billing to ClickHouse: 70% cost cut, integer overflow caught in shadow mode Temporal Cloud moved its billing data store to ClickHouse, cutting steady-state costs roughly 70% and extending runway from about one year to three to five. The hard part wasn't the migration — it was validating correctness for billing-critical queries. They ran both systems in parallel for six weeks, shadowing every query and classifying differences as tolerated, expected, or blocking. Shadow mode caught a real bug: ClickHouse sums 64-bit integers into a same-width accumulator without auto-widening, producing negative totals for large accounts. The fix was casting before aggregating. Rollout was ordered by cost of reversal — read APIs first, billing aggregation last. [Read more](https://daily.dev/posts/RpxL3UwjT) ## pg_clickhouse v0.10: correlated subquery drops from 32.7s to 37ms pg_clickhouse v0.10 advances TPC-H pushdown coverage from 12 to 16 of 22 queries. The headline result is Q17 — a correlated subquery — dropping from 32.7 seconds to 37 milliseconds via full SubPlan pushdown that converts Postgres subqueries into ClickHouse subqueries. The release also fixes a NOT IN bug involving three-valued vs two-valued NULL logic, replaces the C++ clickhouse-cpp driver with a rebuilt C driver to eliminate crash-prone exception/setjmp interactions, and switches the HTTP driver to Native binary format. Subquery pushdown requires ClickHouse 25.8 or newer. [Read more](https://daily.dev/posts/T4GtGJfR1) --- ## Also notable - **SQL Server: temp tables beat CTEs when optimizer estimates are off by 10x or more:** On the Stack Overflow database under SQL Server 2025, a CTE query producing 478,982 logical reads dropped by two-thirds when replaced with a temp table — because the temp table forced fresh statistics that revealed the actual row count (113,399 vs the optimizer's estimate of 14), letting SQL Server pick a scan instead of repeated key lookups. [Read more](https://daily.dev/posts/5pxoOKJ6t) - **Postgres 18 adds io_max_combine_limit with a silent clamp gotcha:** PostgreSQL 18 raises the I/O combine limit ceiling to 128 blocks (1MB) and adds io_max_combine_limit as a postmaster-context GUC — if io_combine_limit exceeds it, the clamp is silent: SHOW reports the requested value, not the effective one, which will burn you on network-attached storage tuning. [Read more](https://daily.dev/posts/fwywLKxSY) - **Percona for MongoDB 8.0.28-12: first native Debian 13 packages, ARM growth nearly 3x in 12 months:** PSMDB 8.0.28-12 adds official support for RHEL 10, Oracle Linux 10, Rocky Linux 10, AlmaLinux 10, and Debian 13 on both x86_64 and ARM — upstream MongoDB Community does not yet support Debian 13; RHEL 10 on x86_64 requires AVX2 (x86-64-v3 baseline). [Read more](https://daily.dev/posts/6dRWJDxRz) - **Snowflake: correlated subqueries in SELECT list cause repeated scans, replacing with JOIN cuts time ~40%:** Snowflake anti-pattern benchmarks show correlated subqueries in the SELECT list trigger repeated table scans; replacing with a JOIN and aggregation reduces execution time roughly 40%, and wrapping filter columns in functions like DATEDIFF disables partition pruning — keeping columns bare cut scanned partitions from 7 to 2. [Read more](https://daily.dev/posts/mouNpGvlh) - **RDS/Aurora CloudWatch log migration to Infrequent Access saves ~$1,250/month per 5 TB/month:** CloudWatch Logs Infrequent Access cuts ingestion costs roughly 50% for RDS and Aurora log groups; a tag-driven Lambda/EventBridge solution automates migration, but there's a temporary log gap during cutover and no support for subscription or metric filters in Infrequent Access class. [Read more](https://daily.dev/posts/aHPw11ypk) ## Similar posts on daily.dev - [PostgreSQL 19 Beta Introduces SQL Graph Queries and Concurrent Table Repacking](https://daily.dev/posts/postgresql-19-beta-introduces-sql-graph-queries-and-concurrent-table-repacking-2adopzbmz) · InfoQ · 91 upvotes · 4 comments --- Tags: [#database](https://daily.dev/tags/database), [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#databricks](https://daily.dev/tags/databricks), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/postgres-19-repack-lands-with-caveats-databricks-acquires-electric-for-neon-j9ivxorpq) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/postgres-19-repack-lands-with-caveats-databricks-acquires-electric-for-neon-j9ivxorpq","headline":"Postgres 19 REPACK lands with caveats, Databricks acquires Electric for Neon","text":"Postgres 19 beta is generating real discussion around REPACK, the new built-in command for online bloat reclamation — but fillfactor interaction is a genuine gotcha worth reading before you touch it in production. Databricks acquired Electric, folding PGlite and the Electric sync engine into Neon. Temporal Cloud's ClickHouse migration cut billing store costs 70% and bought three to five years of runway. pg_clickhouse v0.10 pushes a correlated subquery from 32.7 seconds to 37 milliseconds.","url":"https://daily.dev/posts/postgres-19-repack-lands-with-caveats-databricks-acquires-electric-for-neon-j9ivxorpq","datePublished":"2026-08-12T04:18:03.793Z","dateModified":"2026-08-12T04:18:31.105Z","author":{"@type":"Organization","name":"Databases Digest","logo":"https://media.daily.dev/image/upload/s--ir1hdV8b--/f_auto,q_auto/v1773839400/logos/databases_digest?_a=BAMAMiiu0","url":"https://daily.dev/sources/databases_digest"},"interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/databases_digest","name":"Databases Digest"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Databases Digest","item":"https://daily.dev/sources/databases_digest"},{"@type":"ListItem","position":3,"name":"Postgres 19 REPACK lands with caveats, Databricks acquires Electric for Neon"}]} ```