On tis, 2012-03-13 at 20:34 -0400, Bruce Momjian wrote:
> I frankly am worried that if we copy over statistics even in ASCII
> that don't match what the server expects, it might lead to a crash,
> which has me back to wanting to speed up vacuumdb.
Why can't we maintain a conversion routine for statistics from older
versions? It's not like the statistics layout changes every week.
pg_dump could print out something like
SELECT pg_restore_statistics(catversion, tablename, ... some data ...);
and that function would have the knowledge to convert the data and
insert it back into pg_statistic and pg_class.
That can't be that hard considering all the other work we put into
backward compatibility and upgrade capability.
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2012-03-14 20:43:55|
|Subject: Re: Faster compression, again|
|Previous:||From: Andrew Dunstan||Date: 2012-03-14 20:39:59|
|Subject: Re: patch for parallel pg_dump|