Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit448b02c

Browse files
committed
Additional doc fixes for configurable TOAST compression.
The grammar changes in commitbbe0a81allow SET COMPRESSION to be used with ALTER MATERIALIZED VIEW aswell as with ALTER TABLE, so update those docs to say that it works.Also, update the documentation for the pg_column_compression()to explain that it will return NULL when there's no relevant value.Patch by me, per concerns from Michael Paquier.Discussion:http://postgr.es/m/CA+Tgmob9h5u4iNL9KM0drZgkY-JL4oCVW0dWrMqtLPQ1zHkquA@mail.gmail.com
1 parent2d0f662 commit448b02c

File tree

2 files changed

+3
-1
lines changed

2 files changed

+3
-1
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -26256,7 +26256,8 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup());
2625626256
</para>
2625726257
<para>
2625826258
Shows the compression algorithm that was used to compress a
26259-
an individual variable-length value.
26259+
an individual variable-length value. Returns <literal>NULL</literal>
26260+
if the value is not compressed.
2626026261
</para></entry>
2626126262
</row>
2626226263

‎doc/src/sgml/ref/alter_materialized_view.sgml

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,7 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE <replaceable class="parameter">name</r
4040
ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET ( <replaceable class="parameter">attribute_option</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )
4141
ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> RESET ( <replaceable class="parameter">attribute_option</replaceable> [, ... ] )
4242
ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
43+
ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET COMPRESSION <replaceable class="parameter">compression_method</replaceable>
4344
CLUSTER ON <replaceable class="parameter">index_name</replaceable>
4445
SET WITHOUT CLUSTER
4546
SET ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] )

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp