pgsql: Re-order pg_attribute columns to eliminate some padding space.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Re-order pg_attribute columns to eliminate some padding space.
Дата
Msg-id E1lkqiG-00014C-P0@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Re-order pg_attribute columns to eliminate some padding space.

Now that attcompression is just a char, there's a lot of wasted
padding space after it.  Move it into the group of char-wide
columns to save a net of 4 bytes per pg_attribute entry.  While
we're at it, swap the order of attstorage and attalign to make for
a more logical grouping of these columns.

Also re-order actions in related code to match the new field ordering.

This patch also fixes one outright bug: equalTupleDescs() failed to
compare attcompression.  That could, for example, cause relcache
reload to fail to adopt a new value following a change.

Michael Paquier and Tom Lane, per a gripe from Andres Freund.

Discussion: https://postgr.es/m/20210517204803.iyk5wwvwgtjcmc5w@alap3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f5024d8d7b04de2f5f4742ab433cc38160354861

Modified Files
--------------
doc/src/sgml/catalogs.sgml           | 28 ++++++++++++++--------------
src/backend/access/common/tupdesc.c  | 16 +++++++++++-----
src/backend/access/spgist/spgutils.c |  4 ++--
src/backend/bootstrap/bootstrap.c    | 13 +++++++------
src/backend/catalog/genbki.pl        |  8 ++++----
src/backend/catalog/heap.c           | 19 ++++++++++---------
src/backend/catalog/index.c          | 10 ++++++----
src/backend/commands/tablecmds.c     | 28 ++++++++++++----------------
src/include/access/spgist_private.h  |  2 +-
src/include/catalog/catversion.h     |  2 +-
src/include/catalog/pg_attribute.h   | 22 +++++++++++-----------
11 files changed, 79 insertions(+), 73 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Be more verbose when the postmaster unexpectedly quits.
Следующее
От: David Rowley
Дата:
Сообщение: Re: pgsql: Fix planner's use of Result Cache with unique joins