Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.

Jeff Janes <[email protected]> Mon, 21 Oct 2019 18:20:13 -0400

Newsgroups	gmane.comp.db.postgresql.admin
Message-ID	<CAMkU=1xj5B8_TGRTSyc4ZKO4aPqR4PxmEpzVH0Ld1KrgyWT_EA@mail.gmail.com>

On Mon, Oct 21, 2019 at 1:09 PM Ghiurea, Isabella <
[email protected]> 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