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

Commit0a3edbb

Browse files
committed
Speed up isolation test for concurrent VACUUM/ANALYZE behavior.
Per Tom Lane, the old test sometimes times out with CLOBBER_CACHE_ALWAYS.Nathan BossartDiscussion:http://postgr.es/m/28614.1512583046@sss.pgh.pa.us
1 parent28724fd commit0a3edbb

File tree

2 files changed

+42
-42
lines changed

2 files changed

+42
-42
lines changed

‎src/test/isolation/expected/vacuum-concurrent-drop.out

Lines changed: 27 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -3,74 +3,74 @@ Parsed test spec with 2 sessions
33
starting permutation: lock vac_specified drop_and_commit
44
step lock:
55
BEGIN;
6-
LOCKtest1 IN SHARE MODE;
6+
LOCKpart1 IN SHARE MODE;
77

8-
step vac_specified: VACUUMtest1, test2; <waiting ...>
8+
step vac_specified: VACUUMpart1, part2; <waiting ...>
99
step drop_and_commit:
10-
DROP TABLEtest2;
10+
DROP TABLEpart2;
1111
COMMIT;
1212

13-
WARNING: skipping vacuum of "test2" --- relation no longer exists
13+
WARNING: skipping vacuum of "part2" --- relation no longer exists
1414
step vac_specified: <... completed>
1515

16-
starting permutation: lockvac_all drop_and_commit
16+
starting permutation: lockvac_all_parts drop_and_commit
1717
step lock:
1818
BEGIN;
19-
LOCKtest1 IN SHARE MODE;
19+
LOCKpart1 IN SHARE MODE;
2020

21-
stepvac_all: VACUUM; <waiting ...>
21+
stepvac_all_parts: VACUUM parted; <waiting ...>
2222
step drop_and_commit:
23-
DROP TABLEtest2;
23+
DROP TABLEpart2;
2424
COMMIT;
2525

26-
stepvac_all: <... completed>
26+
stepvac_all_parts: <... completed>
2727

2828
starting permutation: lock analyze_specified drop_and_commit
2929
step lock:
3030
BEGIN;
31-
LOCKtest1 IN SHARE MODE;
31+
LOCKpart1 IN SHARE MODE;
3232

33-
step analyze_specified: ANALYZEtest1, test2; <waiting ...>
33+
step analyze_specified: ANALYZEpart1, part2; <waiting ...>
3434
step drop_and_commit:
35-
DROP TABLEtest2;
35+
DROP TABLEpart2;
3636
COMMIT;
3737

38-
WARNING: skipping analyze of "test2" --- relation no longer exists
38+
WARNING: skipping analyze of "part2" --- relation no longer exists
3939
step analyze_specified: <... completed>
4040

41-
starting permutation: lockanalyze_all drop_and_commit
41+
starting permutation: lockanalyze_all_parts drop_and_commit
4242
step lock:
4343
BEGIN;
44-
LOCKtest1 IN SHARE MODE;
44+
LOCKpart1 IN SHARE MODE;
4545

46-
stepanalyze_all: ANALYZE; <waiting ...>
46+
stepanalyze_all_parts: ANALYZE parted; <waiting ...>
4747
step drop_and_commit:
48-
DROP TABLEtest2;
48+
DROP TABLEpart2;
4949
COMMIT;
5050

51-
stepanalyze_all: <... completed>
51+
stepanalyze_all_parts: <... completed>
5252

5353
starting permutation: lock vac_analyze_specified drop_and_commit
5454
step lock:
5555
BEGIN;
56-
LOCKtest1 IN SHARE MODE;
56+
LOCKpart1 IN SHARE MODE;
5757

58-
step vac_analyze_specified: VACUUM ANALYZEtest1, test2; <waiting ...>
58+
step vac_analyze_specified: VACUUM ANALYZEpart1, part2; <waiting ...>
5959
step drop_and_commit:
60-
DROP TABLEtest2;
60+
DROP TABLEpart2;
6161
COMMIT;
6262

63-
WARNING: skipping vacuum of "test2" --- relation no longer exists
63+
WARNING: skipping vacuum of "part2" --- relation no longer exists
6464
step vac_analyze_specified: <... completed>
6565

66-
starting permutation: lockvac_analyze_all drop_and_commit
66+
starting permutation: lockvac_analyze_all_parts drop_and_commit
6767
step lock:
6868
BEGIN;
69-
LOCKtest1 IN SHARE MODE;
69+
LOCKpart1 IN SHARE MODE;
7070

71-
stepvac_analyze_all: VACUUM ANALYZE; <waiting ...>
71+
stepvac_analyze_all_parts: VACUUM ANALYZE parted; <waiting ...>
7272
step drop_and_commit:
73-
DROP TABLEtest2;
73+
DROP TABLEpart2;
7474
COMMIT;
7575

76-
stepvac_analyze_all: <... completed>
76+
stepvac_analyze_all_parts: <... completed>

‎src/test/isolation/specs/vacuum-concurrent-drop.spec

Lines changed: 15 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -7,39 +7,39 @@
77

88
setup
99
{
10-
CREATETABLEtest1(aINT);
11-
CREATETABLEtest2(aINT);
10+
CREATETABLEparted(aINT)PARTITIONBYLIST(a);
11+
CREATETABLEpart1PARTITIONOFpartedFORVALUESIN(1);
12+
CREATETABLEpart2PARTITIONOFpartedFORVALUESIN(2);
1213
}
1314

1415
teardown
1516
{
16-
DROPTABLEIFEXISTStest1;
17-
DROPTABLEIFEXISTStest2;
17+
DROPTABLEIFEXISTSparted;
1818
}
1919

2020
session"s1"
2121
step"lock"
2222
{
2323
BEGIN;
24-
LOCKtest1INSHAREMODE;
24+
LOCKpart1INSHAREMODE;
2525
}
2626
step"drop_and_commit"
2727
{
28-
DROPTABLEtest2;
28+
DROPTABLEpart2;
2929
COMMIT;
3030
}
3131

3232
session"s2"
33-
step"vac_specified"{VACUUMtest1,test2;}
34-
step"vac_all"{VACUUM;}
35-
step"analyze_specified"{ANALYZEtest1,test2;}
36-
step"analyze_all"{ANALYZE;}
37-
step"vac_analyze_specified"{VACUUMANALYZEtest1,test2;}
38-
step"vac_analyze_all"{VACUUMANALYZE;}
33+
step"vac_specified"{VACUUMpart1,part2;}
34+
step"vac_all_parts"{VACUUMparted;}
35+
step"analyze_specified"{ANALYZEpart1,part2;}
36+
step"analyze_all_parts"{ANALYZEparted;}
37+
step"vac_analyze_specified"{VACUUMANALYZEpart1,part2;}
38+
step"vac_analyze_all_parts"{VACUUMANALYZEparted;}
3939

4040
permutation"lock""vac_specified""drop_and_commit"
41-
permutation"lock""vac_all""drop_and_commit"
41+
permutation"lock""vac_all_parts""drop_and_commit"
4242
permutation"lock""analyze_specified""drop_and_commit"
43-
permutation"lock""analyze_all""drop_and_commit"
43+
permutation"lock""analyze_all_parts""drop_and_commit"
4444
permutation"lock""vac_analyze_specified""drop_and_commit"
45-
permutation"lock""vac_analyze_all""drop_and_commit"
45+
permutation"lock""vac_analyze_all_parts""drop_and_commit"

0 commit comments

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