Re: Optimization of vacuum for logical replication - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Optimization of vacuum for logical replication
Date
Msg-id 3caf7506a19403334851f4c8ec3f655f111a507c.camel@oopsware.de
Whole thread Raw
In response to Re: Optimization of vacuum for logical replication  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Optimization of vacuum for logical replication  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
List pgsql-hackers
Am Mittwoch, den 21.08.2019, 13:26 +0300 schrieb Konstantin Knizhnik:
> Yes, it is possible to have physical replica withotu replication
> slot.
> But it is not safe, because there is always a risk that lag between 
> master and replica becomes larger than size of WAL kept at master.

Sure, but that doesn't mean use cases for this aren't real.

> Also I can't believe that  DBA which explicitly sets wal_level is set
> to 
> logical will use streaming replication without associated replication
> slot.

Well, i know people doing exactly this, for various reasons (short
living replicas, logical replicated table sets for reports, ...). The
fact that they can have loosely coupled replicas with either physical
or logical replication is a feature they'd really miss....

    Bernd




pgsql-hackers by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: Optimization of vacuum for logical replication
Next
From: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Date:
Subject: Re: "ago" times on buildfarm status page