On 8 April 2018 at 15:34, Andrew Gierth <and...@tao11.riddles.org.uk> wrote: > You can't ever assume that data you just inserted will become > all-visible just because you just vacuumed the table, unless you know > that there is NO concurrent activity that might have a snapshot (and no > other possible reason why OldestXmin might be older than your insert).
Thanks. I got it. It just slipped my slightly paranoid and sleep deprived mind. I've attached my proposed fix for the unstable regression tests. I removed the vacuums I'd added in the last version and commented why we're doing set enable_indesonlyscan = off; -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Description: Binary data