Re: Statistics import and export: difference in statistics of materialized view dumped - Mailing list pgsql-hackers

On Wed, Mar 12, 2025 at 4:29 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> I ran my test with this patch (we have to remove 0003 patch in my test
> which uses --no-statistics option). It failed with following
> differences
> @@ -452068,8 +452068,8 @@
> SELECT * FROM pg_catalog.pg_restore_relation_stats(
> 'version', '180000'::integer,
> 'relation', 'public.mvtest_aa'::regclass,
> - 'relpages', '2'::integer,
> - 'reltuples', '1'::real,
> + 'relpages', '0'::integer,
> + 'reltuples', '-1'::real,
> 'relallvisible', '0'::integer
> );
> --
> @@ -452097,8 +452097,8 @@
> SELECT * FROM pg_catalog.pg_restore_relation_stats(
> 'version', '180000'::integer,
> 'relation', 'public.mvtest_tm_type'::regclass,
> - 'relpages', '2'::integer,
> - 'reltuples', '3'::real,
> + 'relpages', '0'::integer,
> + 'reltuples', '-1'::real,
> 'relallvisible', '0'::integer
> );
> --
> @@ -452111,8 +452111,8 @@
> SELECT * FROM pg_catalog.pg_restore_relation_stats(
> 'version', '180000'::integer,
> 'relation', 'public.mvtest_tvmm_expr'::regclass,
> - 'relpages', '2'::integer,
> - 'reltuples', '1'::real,
> + 'relpages', '0'::integer,
> + 'reltuples', '-1'::real,
> 'relallvisible', '0'::integer
> );
> --=== stderr ===
> === EOF ===
>
> The previous differences have disappeared but new differences have appeared.

Pulled the latest sources but the test is still failing with the same
differences.

--
Best Wishes,
Ashutosh Bapat