Odoo Changelog — 2026-08-28

Friday, August 28, 2026

2 changes · 17.0

Improvements(2)

Enhancements to existing features

[IMP] tools/sql: improve query for columns info

Core17.0tools

This update speeds up internal database column lookups by using a more direct query instead of a slower generic system view. It can reduce time spent on these repeated checks during operations such as upgrades, helping improve backend performance without changing user-facing behavior.

Original PR description

Using the view `information_schema.columns` is slow compared to a simplified query using PG catalog tables. Here we propose to cherry pick the parts of the view that we actually use. Below we show…

Using the view `information_schema.columns` is slow compared to a simplified query using PG catalog tables. Here we propose to cherry pick the parts of the view that we actually use.

Below we show the timings of both queries as reported by the system on an upgrade 18->master with a runbot DB (many modules installed). All values are in milliseconds.
```
Original:
    min: 0.931
    max: 16.786
    mean: 1.8790601284296555
    sum: 25750.64
    len: 13704
New:
    min: 0.224
    max: 11.832
    mean: 0.8649024372446001
    sum: 11852.623
    len: 13704
```
Total time spent in queries was halved as seen in the `sum` statistic above.

Technically, the new queries are base on the original information schema view definition as returned by `\d+ information_schema.columns`. With all unused info removed.

Description of the issue/feature this PR addresses:

Current behavior before PR:

Desired behavior after PR is merged:




---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

Forward-Port-Of: odoo/odoo#216309

#performance#database#upgrade

[IMP] l10n_fr_pdp: pilot phase was up to the 1/09/2026.

PR #284186

Core17.0l10n_fr_pdpl10n_fr_pdp_pos

The French PDP configuration no longer shows or uses the pilot phase option because the early participation period has ended. This simplifies setup for companies preparing for the standard French e-invoicing rollout and keeps workflows aligned with the current deadline status.

Original PR description

The pilot phase was there if people wanted to send before the deadline. 
The deadline has been reached, so we can remove the field from the view.




---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

#france#e-invoicing#pdp#configuration

Using the view `information_schema.columns` is slow compared to a simplified query using PG catalog tables. Here we propose to cherry pick the parts of the view that we actually use. Below we show the timings of both queries as reported by the system on an upgrade 18->master with a runbot DB (many modules installed). All values are in milliseconds. ``` Original: min: 0.931 max: 16.786 mean: 1.8790601284296555 sum: 25750.64 len: 13704 New: min: 0.224 max: 11.832 mean: 0.8649024372446001 sum: 11852.623 len: 13704 ``` Total time spent in queries was halved as seen in the `sum` statistic above. Technically, the new queries are base on the original information schema view definition as returned by `\d+ information_schema.columns`. With all unused info removed. Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr Forward-Port-Of: odoo/odoo#216309

The pilot phase was there if people wanted to send before the deadline. The deadline has been reached, so we can remove the field from the view. --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr