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

Commit5b0d7f6

Browse files
Use pg_stat_get_xact* functions within xacts
Resolve build farm failures fromc203d6c,diagnosed by Tom Lane.The output of pg_stat_get_xact_tuples_hot_updated() and friendsis not guaranteed to show anything after the transaction completes.Data is flushed slowly to stats collector, so using them cangive timing issues.
1 parentf4f5845 commit5b0d7f6

File tree

2 files changed

+12
-6
lines changed

2 files changed

+12
-6
lines changed

‎src/test/regress/expected/func_index.out

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
begin;
12
create table keyvalue(id integer primary key, info jsonb);
23
create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=false);
34
insert into keyvalue values (1, '{"name": "john", "data": "some data"}');
@@ -8,7 +9,8 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
89
0
910
(1 row)
1011

11-
drop table keyvalue;
12+
rollback;
13+
begin;
1214
create table keyvalue(id integer primary key, info jsonb);
1315
create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=true);
1416
insert into keyvalue values (1, '{"name": "john", "data": "some data"}');
@@ -33,7 +35,8 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
3335
2
3436
(1 row)
3537

36-
drop table keyvalue;
38+
rollback;
39+
begin;
3740
create table keyvalue(id integer primary key, info jsonb);
3841
create index nameindex on keyvalue((info->>'name'));
3942
insert into keyvalue values (1, '{"name": "john", "data": "some data"}');
@@ -58,4 +61,4 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
5861
2
5962
(1 row)
6063

61-
drop table keyvalue;
64+
rollback;

‎src/test/regress/sql/func_index.sql

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,12 @@
1+
begin;
12
createtablekeyvalue(idintegerprimary key, info jsonb);
23
createindexnameindexon keyvalue((info->>'name')) with (recheck_on_update=false);
34
insert into keyvaluevalues (1,'{"name": "john", "data": "some data"}');
45
update keyvalueset info='{"name": "john", "data": "some other data"}'where id=1;
56
select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
6-
droptable keyvalue;
7+
rollback;
78

9+
begin;
810
createtablekeyvalue(idintegerprimary key, info jsonb);
911
createindexnameindexon keyvalue((info->>'name')) with (recheck_on_update=true);
1012
insert into keyvaluevalues (1,'{"name": "john", "data": "some data"}');
@@ -14,8 +16,9 @@ update keyvalue set info='{"name": "smith", "data": "some other data"}' where id
1416
select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
1517
update keyvalueset info='{"name": "smith", "data": "some more data"}'where id=1;
1618
select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
17-
droptable keyvalue;
19+
rollback;
1820

21+
begin;
1922
createtablekeyvalue(idintegerprimary key, info jsonb);
2023
createindexnameindexon keyvalue((info->>'name'));
2124
insert into keyvaluevalues (1,'{"name": "john", "data": "some data"}');
@@ -25,6 +28,6 @@ update keyvalue set info='{"name": "smith", "data": "some other data"}' where id
2528
select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
2629
update keyvalueset info='{"name": "smith", "data": "some more data"}'where id=1;
2730
select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass);
28-
droptable keyvalue;
31+
rollback;
2932

3033

0 commit comments

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