public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ashutosh Bapat <[email protected]>
To: Jeff Davis <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Corey Huinker <[email protected]>
Subject: Re: Statistics import and export: difference in statistics of materialized view dumped
Date: Thu, 27 Mar 2025 17:07:20 +0530
Message-ID: <CAExHW5uiRcXqXvXs7FfSndHDQsf8bxOS8k=BoC5rx6VLfHBQPg@mail.gmail.com> (raw)
In-Reply-To: <CAExHW5sFRnLkBjcmX8cpUgkKk=zn0WUZJ20ZZ8XUYBgPT0qnhw@mail.gmail.com>
References: <CAExHW5s47kmubpbbRJzSM-Zfe0Tj2O3GBagB7YAyE8rQ-V24Uw@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CAExHW5sFRnLkBjcmX8cpUgkKk=zn0WUZJ20ZZ8XUYBgPT0qnhw@mail.gmail.com>
On Wed, Mar 12, 2025 at 4:29 PM Ashutosh Bapat
<[email protected]> 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
view thread (14+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Statistics import and export: difference in statistics of materialized view dumped
In-Reply-To: <CAExHW5uiRcXqXvXs7FfSndHDQsf8bxOS8k=BoC5rx6VLfHBQPg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox