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

Commitb6ee30e

Browse files
committed
In 002_blocks.pl, try to prevent a HOT update.
Make the new tuple larger than the old one so that it, hopefully, won'tmanage to squeeze into leftover freespace on the same page. The testis trying to verify that the UPDATE touches 2 pages, but if a HOTupdate happens, then it doesn't.Per buildfarm.
1 parentf0106b6 commitb6ee30e

File tree

1 file changed

+2
-1
lines changed

1 file changed

+2
-1
lines changed

‎src/bin/pg_walsummary/t/002_blocks.pl

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -56,7 +56,8 @@
5656

5757
# Update a row in the first block of the table and trigger a checkpoint.
5858
$node1->safe_psql('postgres',<<EOM);
59-
UPDATE mytable SET b = 'abcdefghijklmnopqrstuvwxyz' WHERE a = 2;
59+
UPDATE mytable SET b = 'abcdefghijklmnopqrstuvwxyz' || b || '01234567890'
60+
WHERE a = 2;
6061
CHECKPOINT;
6162
EOM
6263

0 commit comments

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