On Fri, Jan 6, 2012 at 10:25 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Background auto-VACUUMs shouldn't cause this problem because they don't
> take snapshots, and ideally it'd be nice if auto-ANALYZE couldn't create
> the issue either, but ANALYZE does need a snapshot so it's hard to see
> how to avoid having it trip the all-visible logic. Anybody have any
> ideas?
That seems like a huge production problem looming over us, not just a
regression test issue.
I feel like this is a trick question, but I'll ask anyway: Can't we
just ignore ANALYZE?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services