Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Statistics import and export: difference in statistics of materialized view dumped
Date
Msg-id 1427602.1741702648@sss.pgh.pa.us
Whole thread Raw
In response to Statistics import and export: difference in statistics of materialized view dumped  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: Statistics import and export: difference in statistics of materialized view dumped
List pgsql-hackers
Tree view 
Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> writes:
> After fixing the statistics difference in dumps of tables with
> indexes, I now see difference in statistics of materialized view dump
> in the test I am developing at [1] (see the latest patches there).

Are you doing the restore in parallel by any chance?  I had a todo
item to revisit the dependencies that pg_dump is creating for stats
items, because they looked wrong to me, ie inadequate to guarantee
correct restore order.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Mahendra Singh Thalor
Date:
Subject: Re: Non-text mode for pg_dumpall
Next
From: Álvaro Herrera
Date:
Subject: Re: Non-text mode for pg_dumpall