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

Commit08ecdfe

Browse files
author
Amit Kapila
committed
Make FSM test portable.
Inb0eaa4c, we allow FSM to be created only after 4 pages. One of thetests check the FSM contents and to do that it populates many tuples inthe relation. The FSM contents depend on the availability of freespace inthe page and it could vary because of the alignment of tuples.This commit removes the dependency on FSM contents.Author: Amit KapilaDiscussion:https://postgr.es/m/CAA4eK1KADF6K1bagr0--mGv3dMcZ%3DH_Z-Qtvdfbp5PjaC6PJJA%40mail.gmail.com
1 parentb0eaa4c commit08ecdfe

File tree

2 files changed

+7
-19
lines changed

2 files changed

+7
-19
lines changed

‎contrib/pageinspect/expected/page.out

Lines changed: 5 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -35,24 +35,11 @@ ERROR: relation "xxx" does not exist
3535
SELECT octet_length(get_raw_page('test_rel_forks', 'xxx', 0));
3636
ERROR: invalid fork name
3737
HINT: Valid fork names are "main", "fsm", "vm", and "init".
38-
SELECT * FROM fsm_page_contents(get_raw_page('test_rel_forks', 'fsm', 0));
39-
fsm_page_contents
40-
-------------------
41-
0: 39 +
42-
1: 39 +
43-
3: 39 +
44-
7: 39 +
45-
15: 39 +
46-
31: 39 +
47-
63: 39 +
48-
127: 39 +
49-
255: 39 +
50-
511: 39 +
51-
1023: 39 +
52-
2047: 39 +
53-
4095: 39 +
54-
fp_next_slot: 0 +
55-
38+
EXPLAIN (costs off, analyze on, timing off, summary off) SELECT * FROM
39+
fsm_page_contents(get_raw_page('test_rel_forks', 'fsm', 0));
40+
QUERY PLAN
41+
------------------------------------------------------------
42+
Function Scan on fsm_page_contents (actual rows=1 loops=1)
5643
(1 row)
5744

5845
SELECT get_raw_page('test_rel_forks', 0) = get_raw_page('test_rel_forks', 'main', 0);

‎contrib/pageinspect/sql/page.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,8 @@ SELECT octet_length(get_raw_page('test_rel_forks', 'vm', 1)) AS vm_1;
2222
SELECT octet_length(get_raw_page('xxx','main',0));
2323
SELECT octet_length(get_raw_page('test_rel_forks','xxx',0));
2424

25-
SELECT*FROM fsm_page_contents(get_raw_page('test_rel_forks','fsm',0));
25+
EXPLAIN (costs off, analyzeon, timing off, summary off)SELECT*FROM
26+
fsm_page_contents(get_raw_page('test_rel_forks','fsm',0));
2627

2728
SELECT get_raw_page('test_rel_forks',0)= get_raw_page('test_rel_forks','main',0);
2829

0 commit comments

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