| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Russell Foster <russell(dot)foster(dot)coding(at)gmail(dot)com>, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Windows regress fails (latest HEAD) |
| Date: | 2020-11-10 18:15:03 |
| Message-ID: | 2197618.1605032103@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> writes:
> That's unlikely, I think. The regression tests are constructed so that
> the estimates are stable. It's more likely this is some difference in
> rounding behavior, for example.
The reported delta is in the actual row count, not an estimate.
How could that be subject to roundoff issues? And there's no
delta in the Append's inputs, so this seems like it's a flat-out
miss of a row count in EXPLAIN ANALYZE.
> I wonder which msvc builds are used on
> the machines that fail/pass the tests, and if the compiler flags are the
> same.
Yeah, this might be a fruitful way to figure out "what's different
from the buildfarm".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2020-11-10 18:17:53 | Re: [POC] Fast COPY FROM command for the table with foreign partitions |
| Previous Message | Tomas Vondra | 2020-11-10 18:07:07 | Re: MultiXact\SLRU buffers configuration |