| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Synchronized scans |
| Date: | 2007-06-04 20:25:57 |
| Message-ID: | 46647555.8070502@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-06-04 20:42:03 | Re: Synchronized scans |
| Previous Message | Heikki Linnakangas | 2007-06-04 20:24:06 | Re: Synchronized scans |