Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

2016-11-18 Thread Kouhei Kaigai
> On Thu, Nov 17, 2016 at 7:09 PM, Mark Anns wrote: > > Can u explain this statement "check whether the scan qualifier can be > > executable on GPU device" > > > > What are the scan qualifiers? > > > > How to determine whether they are device executable or not? > > > >

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

2016-11-18 Thread Kouhei Kaigai
> Can u explain this statement "check whether the scan qualifier can be > executable on GPU device" > > What are the scan qualifiers? > SELECT * FROM my_table WHERE x > 20 AND memo LIKE '%abc%'; This is scan qualifier. > How to

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

2016-11-14 Thread Kouhei Kaigai
Sorry, I got the question a week before from the sender but couldn't respond timely. > I am reading through Postgres and PGStrom. Regarding the planning factors, > I need some clarifications. Can u help me with that? > > Planner in Postgres checks for different scan and join methods, and then >