Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-27 Thread Jim Nasby
On 8/24/14, 6:22 AM, Haribabu Kommi wrote: Yes, we are mainly targeting CPU-limited sequential scans, Because of this reason only I want the worker to handle the predicates also not just reading the tuples from disk. In that case, I would suggest focusing on parallel execution of conditions re

Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-27 Thread Robert Haas
On Thu, Aug 21, 2014 at 2:47 AM, Haribabu Kommi wrote: > Implementation of "Parallel Sequence Scan" > > Approach: > > 1."Parallel Sequence Scan" can achieved by using the background > workers doing the job of actual sequence scan including the > qualification check also. > > 2. Planner generates t

Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-24 Thread Haribabu Kommi
On Sun, Aug 24, 2014 at 12:34 PM, Craig Ringer wrote: > On 08/24/2014 09:40 AM, Haribabu Kommi wrote: > >> Any suggestions? > > Another point I didn't raise first time around, but that's IMO quite > significant, is that you haven't addressed why this approach to fully > parallel seqscans is useful

Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-23 Thread Craig Ringer
On 08/24/2014 09:40 AM, Haribabu Kommi wrote: > Any suggestions? Another point I didn't raise first time around, but that's IMO quite significant, is that you haven't addressed why this approach to fully parallel seqscans is useful and solves real problems in effective ways. It might seem obviou

Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-23 Thread Haribabu Kommi
On Sun, Aug 24, 2014 at 1:11 AM, Craig Ringer wrote: > On 08/21/2014 02:47 PM, Haribabu Kommi wrote: >> Implementation of "Parallel Sequence Scan" > > I think you mean "Parallel Sequential Scan". Sorry for not being clear, Yes it is parallel sequential scan. >> 1."Parallel Sequence Scan" can ac

Re: [HACKERS] Parallel Sequence Scan doubts

2014-08-23 Thread Craig Ringer
On 08/21/2014 02:47 PM, Haribabu Kommi wrote: > Corrected subject. > > Hi Hackers, > > Implementation of "Parallel Sequence Scan" I think you mean "Parallel Sequential Scan". Scanning a sequence in parallel doesn't make much sense. > 1."Parallel Sequence Scan" can achieved by using the backgro

[HACKERS] Parallel Sequence Scan doubts

2014-08-20 Thread Haribabu Kommi
Corrected subject. Hi Hackers, Implementation of "Parallel Sequence Scan" Approach: 1."Parallel Sequence Scan" can achieved by using the background workers doing the job of actual sequence scan including the qualification check also. 2. Planner generates the parallel scan plan by checking the