Holger Jakobs <holger@xxxxxxxxxx> writes: > Is there a way of exporting statistics data from a database cluster > containing a lot of rows and import them into a similar structured, but > small database cluster. Not at present, AFAIK. There have been discussions of creating a way to do that, and I know of at least one non-public tool that does it, but nobody's pushed things to the point of having code the community would accept. The key stumbling block is inventing a dump representation that would have realistic prospects of still being importable if/when we change the contents of pg_statistic. Certainly there are a lot of applications where cross-version compatibility isn't a requirement; but I don't think the community would take code that isn't usable by pg_upgrade, and for that you need an upgradable design. regards, tom lane
