Odoo Changelog — 2025-12-03

Wednesday, December 3, 2025

1 change · 17.0

Improvements(1)

Enhancements to existing features

[WIP][PERF] *: update index from `True` -> `btree_not_null`

Enterprise17.0accountmarketing_automationplanningsalesocialdocuments

This update improves database storage efficiency by converting certain indexes to a more space-saving format (`btree_not_null`). This change primarily focuses on reducing the amount of disk space used by the Odoo database, without impacting core functionality. It's an internal optimization.

Original PR description

## Description
Update indexes that have a large `null_frac` (the % of NULL value in the column) into `btree_not_null` to save some disk space. Fields who had lookups based on their `False` value weren't converted, unless it's a model we use often and its `null_frac` was `>0.4` which is often the threshold when Postgres will estimate doing a `Seq.Scan` instead.
Fields that had no lookup at all on them, the index was removed.

## Reference
task-3875080

#performance#database#optimization