We created an image of one of our database servers in Rackspace. Then, we created a new server using that image, expecting things to work. However, the index performance we have seen seems to be bad, and even the query plans, when comparing the
explain analyze outputs from the first server to the second one, have been different. Basically, the second server - the one that was restored from a saved image - does not seem to rely on indexes as it should.
Is there something related to image restore that would cause this behavior? If so, what may need to be done to fix the issue? Should I look somewhere else?
Thanks very much! I can provide more information if needed, so let me know if that would be useful.