Re: Intermittent regression test failures from index-only plan changes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Intermittent regression test failures from index-only plan changes
Date
Msg-id CA+U5nML9jEho+poM9y6S78WLWhd-24uvSCPVm95JpJZSVXX7Eg@mail.gmail.com
Whole thread Raw
In response to Intermittent regression test failures from index-only plan changes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Intermittent regression test failures from index-only plan changes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Jan 6, 2012 at 10:25 PM, Tom Lane <tgl@sss.pgh.pa.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


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 16-bit page checksums for 9.2
Next
From: Simon Riggs
Date:
Subject: Re: 16-bit page checksums for 9.2