Re: Query on postgres_fdw extension - Mailing list pgsql-bugs

From Etsuro Fujita
Subject Re: Query on postgres_fdw extension
Date
Msg-id CAPmGK14odzTd8JR7_wuVe81K111+7qAWBRXCwjKd7NrGij0Fbw@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Hi,

On Fri, May 14, 2021 at 6:08 PM Swathi P <swathi.bluepearl@gmail.com> wrote:
> In our sharding solution, we have multiple coodinator nodes. If we declare the table column as serial data type, we
mightend up having duplicate values for id column in the table_a in host_b (data node) as cconnections come from
multiplecoordinatoor nodes and might end up in duplicate key violations. 
>
> Hence we decided to have the coordinator nodes as stateless and hence declared the column with no serial/sequence.
Letme know if this makes sense. 

It seems reasonable to me to make coodinator nodes stateless, but may
I ask the reason you use multiple coordinator nodes?

Best regards,
Etsuro Fujita



pgsql-bugs by date:

Previous
From: David Fetter
Date:
Subject: Re: Query is slow when order by and limit clause are used in the query
Next
From: Eugene Pazhitnov
Date:
Subject: jsonb merge with update ... on conflict do