How can i move aqo data from one db to another?

[nik-weter]

Our db have huge amount queries. For some postgres make good plans, for some - bad. I want to use aqo on copy database. After it gather enough data for changing only required plans of queries, i want to copy aqo data to production db. But i saw only views with names aqo*. Only views? Can i copy views to another bd& And how?

[danolivo]

In AQO 1.5 we store data in db files. Such a decision has some reasons - for example, we avoid sanity check problems of some security applications. But main point here - it is impossible to move ML data to another instance because of different object IDs. The same table on master and replica might have different oids.