git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a717e5c) | patch
Rethink definition of pg_attribute.attcompression.
2021年5月27日 17:24:24 +0000 (13:24 -0400)
2021年5月27日 17:24:27 +0000 (13:24 -0400)
commit e6241d8e030fbd2746b3ea3f44e728224298f35b
Rethink definition of pg_attribute.attcompression.

Redefine '0円' (InvalidCompressionMethod) as meaning "if we need to
compress, use the current setting of default_toast_compression".
This allows '0円' to be a suitable default choice regardless of
datatype, greatly simplifying code paths that initialize tupledescs
and the like. It seems like a more user-friendly approach as well,
because now the default compression choice doesn't migrate into table
definitions, meaning that changing default_toast_compression is
usually sufficient to flip an installation's behavior; one needn't
tediously issue per-column ALTER SET COMPRESSION commands.

Along the way, fix a few minor bugs and documentation issues
with the per-column-compression feature. Adopt more robust
APIs for SetIndexStorageProperties and GetAttributeCompression.

Bump catversion because typical contents of attcompression will now
be different. We could get away without doing that, but it seems
better to ensure v14 installations all agree on this. (We already
forced initdb for beta2, anyway.)

Discussion: https://postgr.es/m/626613.1621787110@sss.pgh.pa.us
29 files changed:
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/config.sgml diff | blob | blame | history
doc/src/sgml/func.sgml diff | blob | blame | history
doc/src/sgml/ref/alter_table.sgml diff | blob | blame | history
doc/src/sgml/ref/create_table.sgml diff | blob | blame | history
doc/src/sgml/ref/pg_dump.sgml diff | blob | blame | history
doc/src/sgml/ref/pg_dumpall.sgml diff | blob | blame | history
doc/src/sgml/storage.sgml diff | blob | blame | history
src/backend/access/brin/brin_tuple.c diff | blob | blame | history
src/backend/access/common/indextuple.c diff | blob | blame | history
src/backend/access/common/toast_internals.c diff | blob | blame | history
src/backend/access/common/tupdesc.c diff | blob | blame | history
src/backend/access/heap/heapam_handler.c diff | blob | blame | history
src/backend/bootstrap/bootstrap.c diff | blob | blame | history
src/backend/catalog/genbki.pl diff | blob | blame | history
src/backend/catalog/heap.c diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/utils/misc/guc.c diff | blob | blame | history
src/bin/pg_dump/pg_backup.h diff | blob | blame | history
src/bin/pg_dump/pg_backup_archiver.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.c diff | blob | blame | history
src/bin/psql/describe.c diff | blob | blame | history
src/include/access/toast_compression.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_attribute.h diff | blob | blame | history
src/test/regress/expected/compression.out diff | blob | blame | history
src/test/regress/expected/compression_1.out diff | blob | blame | history
src/test/regress/sql/compression.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /