Re: Logical replication - initial data synchronization - Mailing list pgsql-docs

From Koen De Groote
Subject Re: Logical replication - initial data synchronization
Date
Msg-id CAGbX52Hq24kwK1YfcoWMEa_Lq16UhEqjd3yA1X46cv1Fz1pbnQ@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication - initial data synchronization  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Logical replication - initial data synchronization
List pgsql-docs
> But perhaps active voice can make it even clearer:

That would be nice. It immediately clarifies the actor, instead of basically saying "it's expected that an action was performed".

To give some context, jobs over the past decade have taught me to work on a default setting of "If it isn't explicitly stated, it cannot be assumed and has to be tested first. Lack of explicit statement is lack of a guarantee, and if you don't test it, you'll run into issues down the line."

To Bruce: I get that concern in general. But I feel like people don't complain because at some point they figure it out, and then it's no longer an issue for them. But it was initially, and it did cost them time. Most people will work with PostgreSQL for their job and their job will demand timely delivery from them. Sending mails like this is probably something most people aren't going to take time for.

At least, that's how I see the situation. It may be presumptive of me.

I realize this has taken a bit of time already, and for my part, I would like the more explicit statement, as shown by Laurenz, but I'm not going to keep going on about it if it doesn't make its way in.

Regards,
Koen De Groote


On Fri, Oct 18, 2024 at 10:11 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2024-10-17 at 16:00 -0400, Bruce Momjian wrote:
> > To me,
> >
> > >    When logical replication of a table typically starts, a snapshot is
> > >    taken of the table's data on the publisher database and copied to the
> > >   subscriber
> >
> > Does not clarify that.
> >
> > It's the reason I created this mail: I would like it stated explicitly that the
> > database process takes care of this for us.
>
> Well, you are the first person to report this confusion, and we can't go
> around explaining what Postgres does and does not do in each section.  I
> would need to hear from other people that this is confusing before
> making it explicit.

I for one would have interpreted the passive voice here as meaning that the
database does that automatically.  But perhaps active voice can make it even
clearer:

  Ordinarily, when logical replication of a table starts,
  <productname>PostgreSQL</productname> takes a snapshot of the table's
  data on the publisher database and copies these data to the subscriber

Yours,
Laurenz Albe

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: ALTER INDEX documentation is incomplete
Next
From: Laurenz Albe
Date:
Subject: Re: Logical replication - initial data synchronization