question is why is it that.
So, even theoretically it is not possible to the the varlena on disk
from logical replication plugin?
Mit freundlichen Grüßen,
Georgy Buranov
not guaranteed in any way to be retained. If that
> weren't the case database tables would bloat while logical replication
> is behind, and the sequential reads (i.e. fast) reads of logical
> decoding would turn into random IO.
Mit freundlichen Grüßen,
Georgy Buranov
> Again, you can set REPLICA IDENTITY to FULL and it'll be there.
>
So, why I think this is complicated
* We use primary keys for all tables, so we do not need REPLICA
IDENTITY full actually. As far as I understand, it will make
master/slave replication ineffective as well
* I need the informatio
Ok, I got false understanding that REPLICA IDENTITY is used for
something more than a WAL. This is basically not true. So, what I can
do
* Set the REPLICA IDENTITY to full, and in this case I can still get
the pk from rd_pkindex. In this case the WAL will be bigger, but we
will have all the values
Hi Andres. Thank you very much for your help.
I tried the following solution and I have some problems.
* I have 9.6 postgres and I do not have separate field for rd_pkindex
* All I have is rd_replidindex field. Usually (when REPLICA IDENTITY
is NOT FULL), it still contains the primary key
* But i
