Re: Related To Hash Partition

From: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
To: Keith <keith(at)keithf4(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Related To Hash Partition
Date: 2023-08-24 16:25:48
Message-ID: CAKDb7aEWMt7rN_LG6Y1veRfMuWqYDde-UqryuKK=T0Aabokyug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am using postgres 14.8 and yes it's rds system.
But on support for rds as we are having basic support plan.

On Thu, 24 Aug, 2023, 9:35 pm Keith, <keith(at)keithf4(dot)com> wrote:

>
>
> On Thu, Aug 24, 2023 at 11:53 AM ROHIT SACHDEVA <
> sachdeva(dot)rohit648(at)gmail(dot)com> wrote:
>
>> Hi Jeff,
>>
>> Today when i am running the updates on a sharding table i.e updating the
>> sharding column with other values.
>>
>> Data has been unsync i.e data should be in the fourth partition
>> according to the explain method but the data is in the first partition.
>>
>> How can I overcome this problem?
>>
>> plz help me with this issue as this is a production issue.
>>
>> Regards
>> Rohit Sachdeva
>>
>>
>>
>>
> I imagine you're going to have to give a concrete, reproducible example
> before anyone is going to be able to assist any further. Also which
> specific, patched version of PG14 to see if there might be a bug that was
> fixed?
>
> Even if that example only works in RDS at least that would narrow this
> down to being an issue specifically there. And if this turns out to only be
> an RDS issue, it at least points out to you that you will likely have to
> contact their support since RDS is actually a proprietary fork of
> PostgreSQL.
>
> Keith
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Victor Sudakov 2023-08-25 11:18:42 Temporary disabling a replica in a Patroni cluster
Previous Message Keith 2023-08-24 16:04:36 Re: Related To Hash Partition