Fwd: BUG #14948: cost overflow - Mailing list pgsql-bugs

From Jan Schulz
Subject Fwd: BUG #14948: cost overflow
Date
Msg-id CAAc324irfhEszHHWcomc6HC5_+6+N3Ryvc=WUqzLVW7ALvj7VQ@mail.gmail.com
Whole thread Raw
In response to BUG #14948: cost overflow  (jasc@gmx.net)
List pgsql-bugs
[resent to the list, sorry Alvaro]

Hello,

On 5 December 2017 at 13:39, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> it seems pretty likely that these are indeed overflows.  However,
> because of the whitespace mangling these plans are pretty much
> impossible to read.  Would you mind pasting these again, as text/plain
> attachment instead?

I attached the plans in plain text.

> Does the query actually take 6ms in the system with the funny explain,
> and 5s on the other?

I didn't really noticed the timings, could be. I was more surprised
that the broken plan actually resulted in zero rows because it should
have had some.

Kind regards,

Jan
--
Jan Schulz
mail: jasc@gmx.net

Attachment

pgsql-bugs by date:

Previous
From: Jan Schulz
Date:
Subject: Re: BUG #14948: cost overflow
Next
From: "Todd A. Cook"
Date:
Subject: Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in aninfinite loop