public inbox for [email protected]  

help / color / mirror / Atom feed
From: kasem adel <[email protected]>
To: Scott Ribe <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Date: Sat, 18 Jan 2025 00:13:23 +0200
Message-ID: <CAP-pBm-Uk9VtTppHu=mrRO=DqM-=asdp_VyQRkFHDosY2tS8vA@mail.gmail.com> (raw)
In-Reply-To: <CAP-pBm9VhXwDbrmQwRTLnFHhDq-f88V97ysL3KrxOX4YGJwYcw@mail.gmail.com>
References: <CAP-pBm9YJqrZQgrH1ZsFt9RbTsOTKH1niS5bEhhB_mSsT49B5Q@mail.gmail.com>
	<[email protected]>
	<CAP-pBm-Y=b6YxHPag0TLertO=7OCo1kN8RVjBg5mvJNx6Y56KA@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAP-pBm-_SNXLaOfPbMxs5WWykwfMdJY6Nmgs21oHo4bJFFxXxg@mail.gmail.com>
	<[email protected]>
	<CAP-pBm9VhXwDbrmQwRTLnFHhDq-f88V97ysL3KrxOX4YGJwYcw@mail.gmail.com>

Dears,

I hope this message finds you well.

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?

Thank you in advance for your assistance.


في الجمعة، ١٧ يناير ٢٠٢٥ ١٠:٥٦ م kasem adel <[email protected]> كتب:

> Dear Scott Ribe,
>
> 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.
>
> Thanks
>
>
>
> في الخميس، ٩ يناير ٢٠٢٥ ٣:٤٤ م Scott Ribe <[email protected]>
> كتب:
>
>> > On Jan 7, 2025, at 6:50 AM, kasem adel <[email protected]> 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.
>
>


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
  In-Reply-To: <CAP-pBm-Uk9VtTppHu=mrRO=DqM-=asdp_VyQRkFHDosY2tS8vA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox