--- title: HypoPG 1.4.4 is out! | daily.dev description: HypoPG 1.4.4 has been released, a PostgreSQL extension for testing hypothetical indexes without building them. The update fixes a memory leak in WITH clause... canonical: https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: HypoPG 1.4.4 is out! | daily.dev og:description: HypoPG 1.4.4 has been released, a PostgreSQL extension for testing hypothetical indexes without building them. The update fixes a memory leak in WITH clause... og:url: https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e og:image: https://api.daily.dev/og/posts/oHvQWkf0e.png og:image:alt: HypoPG 1.4.4 is out! 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. # HypoPG 1.4.4 is out! **[PostgreSQL](https://daily.dev/sources/postgres)** · 2 min read · 0 upvotes · 0 comments ## Summary HypoPG 1.4.4 has been released, a PostgreSQL extension for testing hypothetical indexes without building them. The update fixes a memory leak in WITH clause options and corrects hypothetical index names for Oid values at or above 2^31. It also prevents a failed EXPLAIN from affecting later queries and adds invalidation of hypothetical indexes when dependent objects change. The release includes additional PostgreSQL 19 compatibility fixes. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What bugs were fixed in HypoPG 1.4.4? HypoPG 1.4.4 fixes a memory leak in WITH clause options, corrects the hypothetical index name for Oid values of 2^31 or higher, fixes the indcollation and indclass columns returned by hypopg(), and prevents a failed EXPLAIN from affecting later queries. It also invalidates hypothetical indexes when dependent objects like relations or functions change. _Teams tuning PostgreSQL index strategies can track extension updates like this one on daily.dev._ ### Does HypoPG support PostgreSQL 19? Yes, HypoPG 1.4.4 includes additional compatibility fixes for PostgreSQL 19, alongside support for PostgreSQL 9.2 and above. HypoPG is the extension that adds hypothetical index testing, letting administrators simulate an index's effect on query plans without actually building it. _Anyone upgrading PostgreSQL extensions can follow compatibility updates like this on daily.dev._ ## Similar posts on daily.dev - [pg\_sorted\_heap 0.14.0 released](https://daily.dev/posts/pg-sorted-heap-0-14-0-released-mi4sofvl4) · PostgreSQL · 1 upvotes · 0 comments - [tweaks Version 1.1.0 Released](https://daily.dev/posts/tweaks-version-1-1-0-released-kzvhj55y9) · Planet PostgreSQL · 0 upvotes · 0 comments - [ClickHouse Hypothetical Indexes](https://daily.dev/posts/clickhouse-hypothetical-indexes-pnv4tv1hj) · BigData Boutique blog · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e) ```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":"TechArticle","headline":"HypoPG 1.4.4 is out!","url":"https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e"},"datePublished":"2026-10-26T13:17:09.073Z","dateModified":"2026-10-26T13:20:09.307Z","description":"HypoPG 1.4.4 has been released, a PostgreSQL extension for testing hypothetical indexes without building them. The update fixes a memory leak in WITH clause...","image":"https://media.daily.dev/image/upload/s--OHB84bZF--/f_auto/v1722860399/public/Placeholder%2010","thumbnailUrl":"https://media.daily.dev/image/upload/s--OHB84bZF--/f_auto/v1722860399/public/Placeholder%2010","isAccessibleForFree":true,"articleSection":"PostgreSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"PostgreSQL","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86","url":"https://daily.dev/sources/postgres"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,postgresql","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":3,"name":"HypoPG 1.4.4 is out!"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/hypopg-1-4-4-is-out--ohvqwkf0e#faq","mainEntity":[{"@type":"Question","name":"What bugs were fixed in HypoPG 1.4.4?","acceptedAnswer":{"@type":"Answer","text":"HypoPG 1.4.4 fixes a memory leak in WITH clause options, corrects the hypothetical index name for Oid values of 2^31 or higher, fixes the indcollation and indclass columns returned by hypopg(), and prevents a failed EXPLAIN from affecting later queries. It also invalidates hypothetical indexes when dependent objects like relations or functions change. Teams tuning PostgreSQL index strategies can track extension updates like this one on daily.dev."}},{"@type":"Question","name":"Does HypoPG support PostgreSQL 19?","acceptedAnswer":{"@type":"Answer","text":"Yes, HypoPG 1.4.4 includes additional compatibility fixes for PostgreSQL 19, alongside support for PostgreSQL 9.2 and above. HypoPG is the extension that adds hypothetical index testing, letting administrators simulate an index's effect on query plans without actually building it. Anyone upgrading PostgreSQL extensions can follow compatibility updates like this on daily.dev."}}]} ```