On 8 April 2018 at 15:21, Andrew Gierth <and...@tao11.riddles.org.uk> wrote: > David> Setting autovacuum_naptime to 10 seconds makes it occur in 10 > David> second intervals... > > Analyze (including auto-analyze on a different table entirely) has a > snapshot, which can hold back OldestXmin, hence preventing the > all-visible flag from being set.
urg, that's true. Seems like there's no bugs here then; begin work; set transaction isolation level repeatable read; select * from pg_class; -- do nothing makes the script go crazy. You're right, thanks. I guess the patch I sent is the way forward with this. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
