Postgres Pro
Downloads
Home   >   mailing lists

Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour. - Mailing list pgsql-admin

From Jeff Janes
Subject Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Date
Msg-id CAMkU=1xj5B8_TGRTSyc4ZKO4aPqR4PxmEpzVH0Ld1KrgyWT_EA@mail.gmail.com
Whole thread Raw
In response to PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.  ("Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
Responses Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.  ("Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Tree view
On Mon, Oct 21, 2019 at 1:09 PM Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.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
 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Next
From: "Ghiurea, Isabella"
Date:
Subject: Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.