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

Commit04e7eca

Browse files
committed
Revert "Temporarily instrument postgres_fdw test to look for statistics changes."
This reverts commitc2c537c.It's now clear that whatever is going on there, it can't be blamedon unexpected ANALYZE runs, because the statistics are the samejust before the failing query as they were at the start of the test.
1 parent6a0b30f commit04e7eca

File tree

2 files changed

+0
-44
lines changed

2 files changed

+0
-44
lines changed

‎contrib/postgres_fdw/expected/postgres_fdw.out

Lines changed: 0 additions & 31 deletions
Original file line numberDiff line numberDiff line change
@@ -87,23 +87,6 @@ ANALYZE "S 1"."T 1";
8787
ANALYZE "S 1"."T 2";
8888
ANALYZE "S 1"."T 3";
8989
ANALYZE "S 1"."T 4";
90-
-- record relpages for T 1
91-
create temp table save_t_1_relpages as
92-
select relpages as old_relpages from pg_class where relname = 'T 1';
93-
select relpages - (select old_relpages from save_t_1_relpages) as pg_delta,
94-
reltuples from pg_class where relname = 'T 1';
95-
pg_delta | reltuples
96-
----------+-----------
97-
0 | 1000
98-
(1 row)
99-
100-
select (histogram_bounds::text::int[])[array_length(histogram_bounds,1)]
101-
from pg_stats where tablename = 'T 1' and attname = 'C 1';
102-
histogram_bounds
103-
------------------
104-
1000
105-
(1 row)
106-
10790
-- ===================================================================
10891
-- create foreign tables
10992
-- ===================================================================
@@ -5537,20 +5520,6 @@ UPDATE ft2 SET c3 = 'bar' WHERE postgres_fdw_abs(c1) > 2000 RETURNING *;
55375520
2010 | 0 | bar | | | | ft2 |
55385521
(10 rows)
55395522

5540-
select relpages - (select old_relpages from save_t_1_relpages) as pg_delta,
5541-
reltuples from pg_class where relname = 'T 1';
5542-
pg_delta | reltuples
5543-
----------+-----------
5544-
0 | 1000
5545-
(1 row)
5546-
5547-
select (histogram_bounds::text::int[])[array_length(histogram_bounds,1)]
5548-
from pg_stats where tablename = 'T 1' and attname = 'C 1';
5549-
histogram_bounds
5550-
------------------
5551-
1000
5552-
(1 row)
5553-
55545523
EXPLAIN (verbose, costs off)
55555524
UPDATE ft2 SET c3 = 'baz'
55565525
FROM ft4 INNER JOIN ft5 ON (ft4.c1 = ft5.c1)

‎contrib/postgres_fdw/sql/postgres_fdw.sql

Lines changed: 0 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -95,15 +95,6 @@ ANALYZE "S 1"."T 2";
9595
ANALYZE"S 1"."T 3";
9696
ANALYZE"S 1"."T 4";
9797

98-
-- record relpages for T 1
99-
create temp table save_t_1_relpagesas
100-
select relpagesas old_relpagesfrom pg_classwhere relname='T 1';
101-
102-
select relpages- (select old_relpagesfrom save_t_1_relpages)as pg_delta,
103-
reltuplesfrom pg_classwhere relname='T 1';
104-
select (histogram_bounds::text::int[])[array_length(histogram_bounds,1)]
105-
from pg_statswhere tablename='T 1'and attname='C 1';
106-
10798
-- ===================================================================
10899
-- create foreign tables
109100
-- ===================================================================
@@ -1148,10 +1139,6 @@ INSERT INTO ft2 (c1,c2,c3)
11481139
EXPLAIN (verbose, costs off)
11491140
UPDATE ft2SET c3='bar'WHERE postgres_fdw_abs(c1)>2000 RETURNING*;-- can't be pushed down
11501141
UPDATE ft2SET c3='bar'WHERE postgres_fdw_abs(c1)>2000 RETURNING*;
1151-
select relpages- (select old_relpagesfrom save_t_1_relpages)as pg_delta,
1152-
reltuplesfrom pg_classwhere relname='T 1';
1153-
select (histogram_bounds::text::int[])[array_length(histogram_bounds,1)]
1154-
from pg_statswhere tablename='T 1'and attname='C 1';
11551142
EXPLAIN (verbose, costs off)
11561143
UPDATE ft2SET c3='baz'
11571144
FROM ft4INNER JOIN ft5ON (ft4.c1=ft5.c1)

0 commit comments

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