Re: How to know referenced sub-fields of a composite type?

2019-05-30 Thread Kohei KaiGai
2019/05/30 16:33、Amit Langote のメール: >> On 2019/05/29 15:50, Kohei KaiGai wrote: >> 2019年5月29日(水) 13:26 Amit Langote : It means we can skip to load the sub-fields unreferenced, if query-planner can handle referenced and unreferenced sub-fields correctly. On the other hands, it

Re: How to know referenced sub-fields of a composite type?

2019-05-30 Thread Amit Langote
On 2019/05/29 15:50, Kohei KaiGai wrote: > 2019年5月29日(水) 13:26 Amit Langote : >>> It means we can skip to load the sub-fields unreferenced, if >>> query-planner can handle >>> referenced and unreferenced sub-fields correctly. >>> On the other hands, it looks to me RelOptInfo or other optimizer >>>

Re: How to know referenced sub-fields of a composite type?

2019-05-29 Thread Haribabu Kommi
On Wed, May 29, 2019 at 4:51 PM Kohei KaiGai wrote: > Hi Amit, > > 2019年5月29日(水) 13:26 Amit Langote : > > > > Kaigai-san, > > > > On 2019/05/29 12:13, Kohei KaiGai wrote: > > > One interesting data type in Apache Arrow is "Struct" data type. It is > > > equivalent to composite > > > type in

Re: How to know referenced sub-fields of a composite type?

2019-05-29 Thread Kohei KaiGai
Hi Amit, 2019年5月29日(水) 13:26 Amit Langote : > > Kaigai-san, > > On 2019/05/29 12:13, Kohei KaiGai wrote: > > One interesting data type in Apache Arrow is "Struct" data type. It is > > equivalent to composite > > type in PostgreSQL. The "Struct" type has sub-fields, and individual > > sub-fields

Re: How to know referenced sub-fields of a composite type?

2019-05-28 Thread Amit Langote
Kaigai-san, On 2019/05/29 12:13, Kohei KaiGai wrote: > One interesting data type in Apache Arrow is "Struct" data type. It is > equivalent to composite > type in PostgreSQL. The "Struct" type has sub-fields, and individual > sub-fields have its own > values array for each. > > It means we can

How to know referenced sub-fields of a composite type?

2019-05-28 Thread Kohei KaiGai
Hello, A recent revision of PG-Strom has its columnar-storage using Apache Arrow format files on FDW infrastructure. Because of the columnar nature, it allows to load the values which are referenced by the query, thus, maximizes efficiency of the storage bandwidth.