Hi Stephen, > synchronous_commit isn't the same as synchronous_standby_names ...
What about synchronous_standby_names? Logical replication ignores it and doesn't wait for ack's from replicas or something? > What might be interesting is seeing if Logical Replication could be > added to Patroni as an option and then building on that.. Having > someone involved in the Patroni project would be the right way to go > about proposing that though to see what they think of it. That would > also be much more sensible as a GSoC project, since it'd be an addition > to an existing project and not more-or-less starting a whole new > project. Completely agree, this project can be an improvement for Stolon (or Patroni, but I personally never tested or used it, also I got a feeling that Google guys will prefer a project that is written in Go). This would make much more sense. > Wouldn't it make more sense to have something like what we have for > JSONB where there's operators that are used to pull out specific fields > instead of generated pl/pgsql procedures..? I don't see why we can't have both procedures and operators like: ``` x -> 'field1' -- returns int x ->> 'field2' -- returns string ``` The reason why some users may prefer procedures to operators is that it's easy to make a typo in a field name. Procedures are safer in this regard. -- Best regards, Aleksander Alekseev
signature.asc
Description: PGP signature