Re: [HACKERS] Prepared Statement support for Parallel query

2016-03-14 Thread Amit Kapila
On Tue, Mar 15, 2016 at 12:21 AM, Robert Haas wrote: > > On Mon, Mar 14, 2016 at 9:18 AM, Amit Kapila wrote: > > On Fri, Feb 26, 2016 at 4:37 PM, Robert Haas wrote: > > > > > > The failure cases fall into that category,

Re: [HACKERS] Prepared Statement support for Parallel query

2016-03-14 Thread Robert Haas
On Mon, Mar 14, 2016 at 9:18 AM, Amit Kapila wrote: > On Fri, Feb 26, 2016 at 4:37 PM, Robert Haas wrote: >> And, I'm going to revert this part. If you'd run the regression tests >> under force_parallel_mode=regress, max_parallel_degree>0, you

Re: [HACKERS] Prepared Statement support for Parallel query

2016-03-14 Thread Amit Kapila
On Fri, Feb 26, 2016 at 4:37 PM, Robert Haas wrote: > > > And, I'm going to revert this part. If you'd run the regression tests > under force_parallel_mode=regress, max_parallel_degree>0, you would > have noticed that this part breaks it, because of CREATE TABLE ... AS >

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-26 Thread Amit Kapila
On Fri, Feb 26, 2016 at 4:37 PM, Robert Haas wrote: > > On Thu, Feb 25, 2016 at 1:09 PM, Robert Haas wrote: > > On Thu, Feb 25, 2016 at 8:53 AM, Amit Kapila wrote: > >>> But if the user says > >>> they want to PREPARE the

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-26 Thread Robert Haas
On Thu, Feb 25, 2016 at 1:09 PM, Robert Haas wrote: > On Thu, Feb 25, 2016 at 8:53 AM, Amit Kapila wrote: >>> But if the user says >>> they want to PREPARE the query, they are probably not going to fetch >>> all rows. >> >> After PREPARE, user

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-24 Thread Robert Haas
On Thu, Feb 25, 2016 at 8:53 AM, Amit Kapila wrote: >> But if the user says >> they want to PREPARE the query, they are probably not going to fetch >> all rows. > > After PREPARE, user will execute the statement using EXECUTE and > I don't see how user can decide number

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-24 Thread Amit Kapila
On Wed, Feb 24, 2016 at 7:27 PM, Robert Haas wrote: > On Wed, Feb 17, 2016 at 6:41 PM, Amit Kapila > wrote: > > Commit d1b7c1ffe72e86932b5395f29e006c3f503bc53d has added > > the support for passing bind parameters to parallel workers, however > >

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-24 Thread Robert Haas
On Wed, Feb 17, 2016 at 6:41 PM, Amit Kapila wrote: > Commit d1b7c1ffe72e86932b5395f29e006c3f503bc53d has added > the support for passing bind parameters to parallel workers, however > prepared statement which uses bind parameters wasn't enabled > for parallel query as

Re: [HACKERS] Prepared Statement support for Parallel query

2016-02-24 Thread Robert Haas
On Wed, Feb 17, 2016 at 6:41 PM, Amit Kapila wrote: > Commit d1b7c1ffe72e86932b5395f29e006c3f503bc53d has added > the support for passing bind parameters to parallel workers, however > prepared statement which uses bind parameters wasn't enabled > for parallel query as

[HACKERS] Prepared Statement support for Parallel query

2016-02-17 Thread Amit Kapila
Commit d1b7c1ffe72e86932b5395f29e006c3f503bc53d has added the support for passing bind parameters to parallel workers, however prepared statement which uses bind parameters wasn't enabled for parallel query as the 'Execute' message in FE-BE protocol can pass the row_count which can make parallel