Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Date: 2019-10-21 22:20:13
Message-ID: CAMkU=1xj5B8_TGRTSyc4ZKO4aPqR4PxmEpzVH0Ld1KrgyWT_EA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Oct 21, 2019 at 1:09 PM Ghiurea, Isabella <
Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:

> In PG 9,5.16 we are seeing the correct/expecting number of rows returned
> BUT in in PG 10.9 we are seeing returns 0 rows.
>

If you disable the index (`set enable_bitmapscan=off` should do that) do
you get the same answer on each server?

Cheer,

Jeff

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ghiurea, Isabella 2019-10-22 16:07:58 Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Previous Message Tom Lane 2019-10-21 19:18:13 Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.