Jeff Davis wrote:
> No surprise here, as you and Bruce have already pointed out.
>
> If we wanted to reduce the occurrence of this phenomena, we could
> perhaps "time out" the hints so that it's impossible to pick up a hint
> from a scan that finished 5 minutes ago.
>
> It doesn't seem helpful to further obscure the non-determinism of the
> results, however.
I agree it's probably not a good idea to try masking this. It'll just
make it harder to hit the issue in testing, so that you run into it in
production.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com