Hi Jeff and Corey,
Thanks for fixing the bug related to materialized view statistics. I
have now submitted patches so that the test compares statistics as
well. [1]. However, it is showing a failure on windows only [2].
regress_log has the following difference.
@@ -444546,7 +444546,7 @@
'relname', 'pagg_tab_para_p1',
'relpages', '54'::integer,
'reltuples', '12000'::real,
- 'relallvisible', '0'::integer,
+ 'relallvisible', '54'::integer,
'relallfrozen', '0'::integer
);
SELECT * FROM pg_catalog.pg_restore_attribute_stats(
@@ -444584,7 +444584,7 @@
'relname', 'pagg_tab_para_p2',
'relpages', '45'::integer,
'reltuples', '10000'::real,
- 'relallvisible', '0'::integer,
+ 'relallvisible', '45'::integer,
'relallfrozen', '0'::integer
);
SELECT * FROM pg_catalog.pg_restore_attribute_stats(
@@ -444622,7 +444622,7 @@
'relname', 'pagg_tab_para_p3',
'relpages', '36'::integer,
'reltuples', '8000'::real,
- 'relallvisible', '0'::integer,
+ 'relallvisible', '36'::integer,
'relallfrozen', '0'::integer
);
SELECT * FROM pg_catalog.pg_restore_attribute_stats(
@@ -450930,11 +450930,23 @@
'version', '180000'::integer,
'schemaname', 'public',
'relname', 'test_io_bulkwrite_strategy',
- 'relpages', '0'::integer,
- 'reltuples', '-1'::real,
+ 'relpages', '1'::integer,
+ 'reltuples', '100'::real,
'relallvisible', '0'::integer,
'relallfrozen', '0'::integer
);
+SELECT * FROM pg_catalog.pg_restore_attribute_stats(
+ 'version', '180000'::integer,
+ 'schemaname', 'public',
+ 'relname', 'test_io_bulkwrite_strategy',
+ 'attname', 'i',
+ 'inherited', 'f'::boolean,
+ 'null_frac', '0'::real,
+ 'avg_width', '4'::integer,
+ 'n_distinct', '-1'::real,
+ 'histogram_bounds',
'{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100}'::text,
+ 'correlation', '1'::real
+);
First 3 and 5th differences are new differences but we have seen
something similar to the 4th one previously.
I am not able to reproduce the failure even after running it 30 times
on my linux laptop.
[1]
https://www.postgresql.org/message-id/caexhw5vvftcejh+uyznxmgsxofj_1xwi5aqhqfemqjgfmky...@mail.gmail.com
[2] https://cirrus-ci.com/task/5164175841820672
--
Best Wishes,
Ashutosh Bapat
