regression.diffs
text/x-diff
Filename: regression.diffs
Type: text/x-diff
Part: 0
Patch
Format: unified
| File | + | − |
|---|---|---|
| /home/postgres/pgsql/src/test/regress/results/temp.out | 32 | 0 |
diff -U3 /home/postgres/pgsql/src/test/regress/expected/temp.out /home/postgres/pgsql/src/test/regress/results/temp.out
--- /home/postgres/pgsql/src/test/regress/expected/temp.out 2019-08-05 11:20:31.612729499 -0400
+++ /home/postgres/pgsql/src/test/regress/results/temp.out 2019-08-11 15:45:24.471393832 -0400
@@ -273,6 +273,36 @@
(1 row)
-- two relations remain in this case.
+explain
+select relname from pg_class where relname like 'temp_parted_oncommit_test%';
+ QUERY PLAN
+-------------------------------------------------------------------------------------------------
+ Index Only Scan using pg_class_relname_nsp_index on pg_class (cost=0.28..8.30 rows=1 width=64)
+ Index Cond: ((relname >= 'temp'::text) AND (relname < 'temq'::text))
+ Filter: (relname ~~ 'temp_parted_oncommit_test%'::text)
+(3 rows)
+
+set enable_indexonlyscan TO 0;
+explain
+select relname from pg_class where relname like 'temp_parted_oncommit_test%';
+ QUERY PLAN
+--------------------------------------------------------------------------------------------
+ Index Scan using pg_class_relname_nsp_index on pg_class (cost=0.28..8.30 rows=1 width=64)
+ Index Cond: ((relname >= 'temp'::text) AND (relname < 'temq'::text))
+ Filter: (relname ~~ 'temp_parted_oncommit_test%'::text)
+(3 rows)
+
+set enable_indexscan TO 0;
+explain
+select relname from pg_class where relname like 'temp_parted_oncommit_test%';
+ QUERY PLAN
+-----------------------------------------------------------------------------------------
+ Bitmap Heap Scan on pg_class (cost=4.29..8.30 rows=1 width=64)
+ Filter: (relname ~~ 'temp_parted_oncommit_test%'::text)
+ -> Bitmap Index Scan on pg_class_relname_nsp_index (cost=0.00..4.29 rows=1 width=0)
+ Index Cond: ((relname >= 'temp'::text) AND (relname < 'temq'::text))
+(4 rows)
+
select relname from pg_class where relname like 'temp_parted_oncommit_test%';
relname
----------------------------
@@ -280,6 +310,8 @@
temp_parted_oncommit_test1
(2 rows)
+reset enable_indexscan;
+reset enable_indexonlyscan;
drop table temp_parted_oncommit_test;
-- Check dependencies between ON COMMIT actions with inheritance trees.
-- Using ON COMMIT DROP on a parent removes the whole set.