Re: [GENERAL] Unexpected query result

2015-10-05 Thread Adrian Klaver
On 10/05/2015 05:02 AM, Begin Daniel wrote: In order to process a large amount of data I need to run a procedure using parallel batch processes. The query I run in each process is expected to ... 1- select a bunch of id (500) in a table (wait4processing) containing the list of all records to

[GENERAL] Unexpected query result

2015-10-05 Thread Begin Daniel
In order to process a large amount of data I need to run a procedure using parallel batch processes. The query I run in each process is expected to ... 1- select a bunch of id (500) in a table (wait4processing) containing the list of all records to process2- remove selected records from

Re: [GENERAL] Unexpected query result

2015-10-05 Thread Begin Daniel
Thank Adrian, it makes sense. I'll adapt the calling procedures Daniel > Subject: Re: [GENERAL] Unexpected query result > To: jfd...@hotmail.com; pgsql-general@postgresql.org > From: adrian.kla...@aklaver.com > Date: Mon, 5 Oct 2015 06:17:33 -0700 > > On 10/05/2015 05:02 AM,

Re: [GENERAL] Unexpected query result

2015-10-05 Thread dinesh kumar
Hi, On Mon, Oct 5, 2015 at 5:02 AM, Begin Daniel wrote: > In order to process a large amount of data I need to run a procedure using > parallel batch processes. > The query I run in each process is expected to ... > > It seems, you are trying to achieve the same, what we