pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedToasted column values during replication
3+ messages / 2 participants
[nested] [flat]
* Toasted column values during replication
@ 2023-06-30 17:06 Chandy G <vgchandru@yahoo.com>
2023-06-30 19:52 ` Re: Toasted column values during replication Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 3+ messages in thread
From: Chandy G @ 2023-06-30 17:06 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi PG Users, We are running into the postgres toasted values showing up in replication slots. We are using debezium and have gone through the following
1. Various options for handling toasted values during replication at the application level.2. Postgres option to turn on replica identitiy to full.
While these are solutions to the problem. Wanted to understand if there is any scope for enhancement / improvements in postgres itself to handle such scenarios.
For instance : Can the postgres internal component (wal-sender / *) interpret this special toasted-col-value sitting in the wal-file -> replace it with the actual value and send it to the replication slot. I presume, today the wal-sender does not have this support and it just sends whatever data that the wal log has. So if the wal-sender - can intercept such toasted values and translate it to actual values before being sent - that would solve the problem without every consumer having to implement a solution to handle toasted value. This would also help prevent the unwarranted increase of the wal-log if replica-identity to full is set as a w/a.
Any thoughts?
Thanks.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Toasted column values during replication
2023-06-30 17:06 Toasted column values during replication Chandy G <vgchandru@yahoo.com>
@ 2023-06-30 19:52 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-07-15 20:42 ` Re: Toasted column values during replication Chandy G <vgchandru@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2023-06-30 19:52 UTC (permalink / raw)
To: Chandy G <vgchandru@yahoo.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On Fri, 2023-06-30 at 17:06 +0000, Chandy G wrote:
> For instance : Can the postgres internal component (wal-sender / *) interpret this special
> toasted-col-value sitting in the wal-file -> replace it with the actual value and send it to
> the replication slot.
Which logical decoding plugin are you using?
"pgoutput", which is provided by PostgreSQL, will surely emit properly detoasted values.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Toasted column values during replication
2023-06-30 17:06 Toasted column values during replication Chandy G <vgchandru@yahoo.com>
2023-06-30 19:52 ` Re: Toasted column values during replication Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-07-15 20:42 ` Chandy G <vgchandru@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Chandy G @ 2023-07-15 20:42 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; Laurenz Albe <laurenz.albe@cybertec.at>
Using pgoutput - aws rds 13* version and seeing this behavior when using it with debezium 2.0.0 version.
Best.
On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2023-06-30 at 17:06 +0000, Chandy G wrote:
> For instance : Can the postgres internal component (wal-sender / *) interpret this special
> toasted-col-value sitting in the wal-file -> replace it with the actual value and send it to
> the replication slot.
Which logical decoding plugin are you using?
"pgoutput", which is provided by PostgreSQL, will surely emit properly detoasted values.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-07-15 20:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-30 17:06 Toasted column values during replication Chandy G <vgchandru@yahoo.com>
2023-06-30 19:52 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-07-15 20:42 ` Chandy G <vgchandru@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox