pgsql: Simplify pg_mcv_list (de)serialization - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Simplify pg_mcv_list (de)serialization
Date
Msg-id E1hjCfw-0001ax-Dr@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Simplify pg_mcv_list (de)serialization

The serialization format of multivariate MCV lists included alignment in
order to allow direct access to part of the serialized data, but despite
multiple fixes (see for example commits d85e0f366a and ea4e1c0e8f) this
proved to be problematic.

This commit abandons alignment in the serialized format, and just copies
everything during deserialization.  We now also track amount of memory
needed after deserialization (including alignment), which allows us to
deserialize the MCV list in a single pass.

Bump catversion, as this affects contents of pg_statistic_ext_data.

Backpatch to 12, where multi-column MCV lists were introduced.

Author: Tomas Vondra
Reviewed-by: Tom Lane
Discussion: https://postgr.es/m/2201.1561521148@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/08aa131c7a72195113ab3a7b191fe8014dd3a898

Modified Files
--------------
src/backend/statistics/mcv.c                     | 291 ++++++++++++++---------
src/include/catalog/catversion.h                 |   2 +-
src/include/statistics/extended_stats_internal.h |   1 +
3 files changed, 183 insertions(+), 111 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Remove unnecessary casts from size_t to int
Next
From: Michael Paquier
Date:
Subject: pgsql: Update hardcoded DH parameters to IANA standards