Horton

Re: BUG #15577: Query returns different results when executed multiple times

Thomas Munro <thomas.munro@enterprisedb.com>

View thread View on postgr.es
From: Thomas Munro <thomas.munro@enterprisedb.com>
To: Bartosz Polnik <bartoszpolnik@gmail.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2019-01-09T20:31:57Z
Lists: pgsql-bugs 
On Wed, Jan 9, 2019 at 8:48 PM Bartosz Polnik <bartoszpolnik@gmail.com> wrote:
> Thomas, I tried to reproduce this case with changes you listed, but failed to do that - the number of results was the same on each run. Could you post an updated script in an attachment?

Probably due to timing of parallel worker startup.  Different
computers, operating systems, alignment of the stars etc.  Debugging
parallel query problems is fun like that.

-- 
Thomas Munro
http://www.enterprisedb.com

Commits

  1. Avoid sharing PARAM_EXEC slots between different levels of NestLoop.