| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Seth P <seth-p(at)outlook(dot)com> |
| Subject: | Re: BUG #13908: Query returns too few rows |
| Date: | 2016-02-05 05:17:17 |
| Message-ID: | CAKFQuwbgT680S1PJc1BKrm1E+KQYXrHg760_nzxXt0=ujnXVwg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Feb 4, 2016 at 9:47 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On this node's detail (the rows seems to appear consistently regardless of
> node ordering in the plan...)
> Hash (cost=1440572.59..1440572.59 rows=872393 width=24) (actual
> time=151981.919..151981.919 rows=*1275138* loops=1)
>
> Bad Plan:
>
>
> Buckets: 131072 (originally 131072) Batches: 32 (originally 16) Memory
> Usage: 3073kB
>
Final result: 415,967 / 416,075 (108 missing)
> Bad Plan: Buckets: 65536 (originally 65536) Batches: 32 (originally
> 16) Memory Usage: 3585kB
>
Final result: 415,874 / 416,075 (201 missing)
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-02-05 05:38:34 | Re: BUG #13908: Query returns too few rows |
| Previous Message | David G. Johnston | 2016-02-05 04:47:32 | Re: BUG #13908: Query returns too few rows |