Thank you for your support. After completing the upgrade process, we encountered high disk IO due to queries selecting incorrect plans for specific table. When we ran ANALYZE, it did not choose the correct plan, likely because we are using the default ANALYZE settings, and our data size is approximately 1.8 TB. Could you kindly provide a solution to address this issue?
Thanks for your support after upgrade process we faced high disk IO because query chose wrong plann but when run analyze not chose the correct plan because we are used default analyze and data size is 1.8 TB can you provide us with solution to solve this issue.
> On Jan 7, 2025, at 6:50 AM, kasem adel <kasemadel8@gmail.com> wrote: > > Kindly be informed that database size is 1.8 TB and we have an low network bandwidth between two node 10 mbps and to transfer the data from scratch that will take from 21 day to 30 day for this we need solution in upgrade to prevent load data from scratch .
Yes, and I gave you alternatives taking that into account. I think you have all the answers you're going to get, and now have to study them and choose an approach.
