On Tue, Oct 6, 2026 at 6:39 AM Stuart Campbell < [email protected]> wrote: [snip]
> Would using temporary tables be a feasible solution? That seems to be > functionally what I want, but maybe it's hard to write triggers that write > to temp tables. > > Maybe a persistent log table is OK, and each transaction is > responsible for deleting its own rows from it? Sounds like a lot of churn > though... > A recent email in https://postgrespro.com/list/thread-id/2812560#[email protected] mentioned this extension to create "persistent" temporary tables (where each connection doesn't need to CREATE them every time. https://github.com/darold/pgtt Maybe that would be useful. I've never used them, though, so don't know any gotchas. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
