reating index on it, update perf will satisfy.
>
> Burcin 📱
>
> > On 11 Aug 2023, at 07:49, David Rowley wrote:
> >
> > On Thu, 10 Aug 2023 at 20:36, Dorian Hoxha
> wrote:
> >>> Do Not Use Partial Indexes as a Substitute for Partitioning
> >>> Whi
Hi list,
I have a queue table with the schema:
```
create table queue(id bigserial primary key, view_time timestamp with
timezone not null);
create index queue_view_time ON queue(view_time ASC);
```
The most concurrent operation is:
```
UPDATE queue SET view_time=view_time+INTERVAL '60 seconds'
Look into patroni, pg_auto_failover, postgres-operator.
On Tue, Mar 2, 2021 at 12:59 PM Rodriguez Pablo A <
rodriguez.a.pa...@gmail.com> wrote:
> Hi, I have to configure a postgresql in high availability.
> I want to ask you what tool you recommend to manage replication and
> failover or switchov
