Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
nik-weter opened this issue Nov 23, 2022 · 1 comment
Open

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

nik-weter opened this issue Nov 23, 2022 · 1 comment

Comments

@nik-weter
Copy link

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
Copy link
Collaborator

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants