Re: [BUGS] Differences in COUNT result when enabling parallel query - Mailing list pgsql-bugs

From Alastair James
Subject Re: [BUGS] Differences in COUNT result when enabling parallel query
Date
Msg-id CAB2JvMKxF_z+NJquVW4-u1Ac-z8jzrgLmCsWqkekTF6KBVc6Jg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] Differences in COUNT result when enabling parallel query  (Euler Taveira <euler@timbira.com.br>)
List pgsql-bugs
Many thanks.

Lets hope AWS update RDS to 9.6.2 soon.

Cheers

Al

On Wed, Mar 15, 2017 at 3:33 PM, Euler Taveira <euler@timbira.com.br> wrote:
2017-03-15 5:27 GMT-03:00 Alastair James <al@ometria.com>:
I was wondering if this is a known issue? Maybe fixed in 9.6.2? If so lets hope AWS RDS updates soon.

Yes, it is (see similar bug report in the commit message) and was fixed in 9.6.2 [1]. The workaround is to disable parallel query for this query.


[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=41e2b84ce1b89ae0125dd34318c56aa51386e2a2


--
   Euler Taveira                                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento



--

Alastair James

Co-Founder and Chief Technology Officer

Tel +44 (0) 20 7016 8408

We're recruiting new Ometrians!

pgsql-bugs by date:

Previous
From: Euler Taveira
Date:
Subject: Re: [BUGS] Differences in COUNT result when enabling parallel query
Next
From: "Wiler Coelho Jr."
Date:
Subject: Re: [BUGS] Error floating-point exception on postgresql installer