Re: ERROR: no known snapshots

2021-05-12 Thread Tom Lane
reg_pg_stef...@perfexpert.ch writes: > However, I poked around a little bit, and this does not seem to solve > all potential use cases, when I modify the simplified test by deferring > the lookup to be done inside the loop as an extra lookup instead of > doing it directly in the loop (whether th

Re: ERROR: no known snapshots

2021-05-12 Thread reg_pg_stefanz
On 12.05.2021 05:42, Tom Lane wrote: If you're in a position to apply the patch and see if it resolves your real non-simplified case, that would be very helpful. Also, this fix in principle will create a small performance penalty for FOR-loops in non-atomic contexts such as DO loops. It'd be int

Re: ERROR: no known snapshots

2021-05-11 Thread Tom Lane
reg_pg_stef...@perfexpert.ch writes: > it run into an issue with: ERROR:  no known snapshots Hi! This has been reported before, but I'm embarrassed to say that the previous report seems to have fallen between the cracks. I've created a patch [1] that resolves your example as presented. If you're