Thanks for confirming my suspicions, I'm working on a plan B to deal with this as best I can.
--
Mike Nolan
On Mon, Apr 4, 2022 at 9:23 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
On Mon, 2022-04-04 at 09:18 -0500, Michael Nolan wrote:
> Is it not recommended to use a FDW table in a trigger function?
Yes, I would say that is not recommended. While a lag of a few seconds,
like you describe, should not be the normal case (you should investigate that),
it is hard to exclude it in the face of network failures (you could end up
waiting for the keepalive timeout of 2 hours).
So the trigger can potentially run a long time, which makes your transaction
long. A long transaction can block other sessions or autovacuum progress.
The rule of thumb is that you should have nothing inside a database transaction
that *could* take a long time (even if it is normally fast).
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
