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

Commit6ceec8a

Browse files
committed
doc: pg_resetwal: Add comments how the multipliers are derived
Reviewed-by: Aleksander Alekseev <aleksander@timescale.com>Discussion:https://www.postgresql.org/message-id/flat/0f3ab4a1-ae80-56e8-3426-6b4a02507687@eisentraut.org
1 parent93c85db commit6ceec8a

File tree

1 file changed

+7
-1
lines changed

1 file changed

+7
-1
lines changed

‎doc/src/sgml/ref/pg_resetwal.sgml

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -166,7 +166,8 @@ PostgreSQL documentation
166166
<command>pg_resetwal</command> is unable to determine appropriate values
167167
by reading <filename>pg_control</filename>. Safe values can be determined as
168168
described below. For values that take numeric arguments, hexadecimal
169-
values can be specified by using the prefix <literal>0x</literal>.
169+
values can be specified by using the prefix <literal>0x</literal>. Note
170+
that these instructions only apply with the standard block size of 8 kB.
170171
</para>
171172

172173
<variablelist>
@@ -189,6 +190,7 @@ PostgreSQL documentation
189190
greatest file name in the same directory. The file names are in
190191
hexadecimal.
191192
</para>
193+
<!-- XXX: Should there be a multiplier, similar to the other options? -->
192194
</listitem>
193195
</varlistentry>
194196

@@ -272,6 +274,7 @@ PostgreSQL documentation
272274
names are in hexadecimal, so the easiest way to do this is to specify
273275
the option value in hexadecimal and append four zeroes.
274276
</para>
277+
<!-- 65536 = SLRU_PAGES_PER_SEGMENT * BLCKSZ / sizeof(MultiXactOffset) -->
275278
</listitem>
276279
</varlistentry>
277280

@@ -306,6 +309,7 @@ PostgreSQL documentation
306309
The file names are in hexadecimal. There is no simple recipe such as
307310
the ones for other options of appending zeroes.
308311
</para>
312+
<!-- 52352 = SLRU_PAGES_PER_SEGMENT * floor(BLCKSZ/20) * 4; see multixact.c -->
309313
</listitem>
310314
</varlistentry>
311315

@@ -354,6 +358,7 @@ PostgreSQL documentation
354358
in <filename>pg_xact</filename>, <literal>-u 0x700000</literal> will work (five
355359
trailing zeroes provide the proper multiplier).
356360
</para>
361+
<!-- 1048576 = SLRU_PAGES_PER_SEGMENT * BLCKSZ * CLOG_XACTS_PER_BYTE -->
357362
</listitem>
358363
</varlistentry>
359364

@@ -375,6 +380,7 @@ PostgreSQL documentation
375380
in <filename>pg_xact</filename>, <literal>-x 0x1200000</literal> will work (five
376381
trailing zeroes provide the proper multiplier).
377382
</para>
383+
<!-- 1048576 = SLRU_PAGES_PER_SEGMENT * BLCKSZ * CLOG_XACTS_PER_BYTE -->
378384
</listitem>
379385
</varlistentry>
380386
</variablelist>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp