Re: BUG #13908: Query returns too few rows

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #13908: Query returns too few rows
Дата
Msg-id CAKFQuwbgT680S1PJc1BKrm1E+KQYXrHg760_nzxXt0=ujnXVwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #13908: Query returns too few rows  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: BUG #13908: Query returns too few rows
Список pgsql-bugs
Дерево обсуждения 
On Thu, Feb 4, 2016 at 9:47 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On this node's detail (the rows seems to appear consistently regardless o=
f
> node ordering in the plan...)
> Hash  (cost=3D1440572.59..1440572.59 rows=3D872393 width=3D24) (actual
> time=3D151981.919..151981.919 rows=3D*1275138* loops=3D1)
>


> Bad Plan: =E2=80=8B
>
> =E2=80=8B  =E2=80=8B
> Buckets: 131072 (originally 131072)  Batches: 32 (originally 16)  Memory
> Usage: 3073kB
>

Final result: =E2=80=8B415,967 / =E2=80=8B416,075 (108 missing)


> =E2=80=8BBad Plan:  =E2=80=8B  Buckets: 65536 (originally 65536)  Batches=
: 32 (originally
> 16)  Memory Usage: 3585kB
>

=E2=80=8BFinal result: 415,874 / 416,075 (201 missing)=E2=80=8B

=E2=80=8BDavid J.=E2=80=8B

В списке pgsql-bugs по дате отправления: