On Mon, Jan 25, 2016 at 9:09 PM, Kouhei Kaigai wrote:
> Of course, its implementation is not graceful enough, especially, above
> point because this extra filter will change expected number of rows to
> be produced by inner relation, and relevant cost.
> Right now, his patch calls cost_seqscan() a
> On Tue, Jan 19, 2016 at 7:59 AM, Greg Stark wrote:
> > On Mon, Jan 18, 2016 at 5:55 PM, Robert Haas wrote:
> >> For
> >> example, suppose that x and y are numeric columns and P(x) is
> >> length(x::text) == 3. Then you could have 1 in one table and 1.0 in
> >> the table; they join, but P(x) is
On Tue, Jan 19, 2016 at 7:59 AM, Greg Stark wrote:
> On Mon, Jan 18, 2016 at 5:55 PM, Robert Haas wrote:
>> For
>> example, suppose that x and y are numeric columns and P(x) is
>> length(x::text) == 3. Then you could have 1 in one table and 1.0 in
>> the table; they join, but P(x) is true for on
On Mon, Jan 18, 2016 at 5:55 PM, Robert Haas wrote:
> For
> example, suppose that x and y are numeric columns and P(x) is
> length(x::text) == 3. Then you could have 1 in one table and 1.0 in
> the table; they join, but P(x) is true for one and false for the
> other.
Fwiw, ages ago there was so
On Tue, Dec 22, 2015 at 8:36 AM, Michael Paquier
wrote:
> On Fri, Nov 20, 2015 at 9:05 PM, Taiki Kondo wrote:
>> I created v3 patch for this feature, and v1 patch for regression tests.
>> Please find attached.
>>
>> [blah review and replies]
>>
>> Please find from attached patch.
>
> This new pat
On Fri, Nov 20, 2015 at 9:05 PM, Taiki Kondo wrote:
> I created v3 patch for this feature, and v1 patch for regression tests.
> Please find attached.
>
> [blah review and replies]
>
> Please find from attached patch.
This new patch did not actually get a review, moved to next CF.
--
Michael
--
Hello, sorry for late response and thank you for the new patch.
At Fri, 20 Nov 2015 12:05:38 +, Taiki Kondo wrote
in <12a9442fbae80d4e8953883e0b84e08863f...@bpxm01gp.gisp.nec.co.jp>
>
> I created v3 patch for this feature, and v1 patch for regression tests.
> Please find attached.
I think
ways child table.
*/
- if (em->em_is_child &&
+ if (relids != NULL &&
+ em->em_is_child &&
!bms_equal(em->em_relids, relids))
continue;
It is a little bit hard to u
KaiGai Kohei
> -Original Message-
> From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Taiki Kondo
> Sent: Wednesday, October 21, 2015 8:07 PM
> To: Kaigai Kouhei(海外 浩平); Kyotaro HORIGUCHI
> Cc: pgsql-hackers@postgresql.org; Y
Of Taiki Kondo
> Sent: Thursday, October 08, 2015 5:28 PM
> To: Kyotaro HORIGUCHI
> Cc: Kaigai Kouhei(海外 浩平); Iwaasa Akio(岩浅 晃郎);
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [Proposal] Table partition + join pushdown
>
> Hello, Horiguchi-san.
>
> Thank you f
r designing more cleanly.
Best regards,
--
Taiki Kondo
NEC Solution Innovators, Ltd.
-Original Message-
From: Kyotaro HORIGUCHI [mailto:horiguchi.kyot...@lab.ntt.co.jp]
Sent: Thursday, October 08, 2015 7:04 PM
To: tai-ko...@yk.jp.nec.com
Cc: kai...@ak.jp.nec.com; aki-iwa...@vt.jp.nec.com
tgresql.org
> Subject: Re: [HACKERS] [Proposal] Table partition + join pushdown
>
> Hello, Horiguchi-san.
>
> Thank you for your comment.
>
> > I got some warning on compilation on unused variables and wrong
> > arguemtn type.
>
> OK, I'll fix it.
>
Hello, thank you for the example.
I could see this patch working with it.
> > In make_restrictinfos_from_check_constr, the function returns
> > modified constraint predicates correspond to vars under
> > hashjoinable join clauses. I don't think expression_tree_mutator
> > is suitable to do that s
ondo
NEC Solution Innovators, Ltd.
-Original Message-
From: Kyotaro HORIGUCHI [mailto:horiguchi.kyot...@lab.ntt.co.jp]
Sent: Tuesday, October 06, 2015 8:35 PM
To: tai-ko...@yk.jp.nec.com
Cc: kai...@ak.jp.nec.com; aki-iwa...@vt.jp.nec.com; pgsql-hackers@postgresql.org
Subject: Re: [HACK
Hello.
I tried to read this and had some random comments on this.
-- general
I got some warning on compilation on unused variables and wrong
arguemtn type.
I failed to have a query that this patch works on. Could you let
me have some specific example for this patch?
This patch needs more comme
September 30, 2015 11:19 PM
To: Kondo Taiki(近藤 太樹)
Cc: Iwaasa Akio(岩浅 晃郎); pgsql-hackers@postgresql.org
Subject: RE: [HACKERS] [Proposal] Table partition + join pushdown
> > * Suppose we focus on only HashJoin in the first version?
> > This patch also add support on NestLoop and MergeJoin
ards,
> --
> Taiki Kondo
>
> NEC Solution Innovators, Ltd.
>
>
>
> -Original Message-
> From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Kouhei Kaigai
> Sent: Tuesday, September 29, 2015 11:46 AM
>
l.org
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Kouhei Kaigai
Sent: Tuesday, September 29, 2015 11:46 AM
To: Taiki Kondo
Cc: Akio Iwaasa; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [Proposal] Table partition + join pushdown
> -Original Message-
> From: pgsql-h
ression nodes
>
> All this patch supported is CHECK() constraint with equal operation on INT4
> data
> type. You can learn various useful infrastructure of PostgreSQL. For example,
> ...
> - expression_tree_mutator() is useful to make a copy of expression
> node wit
Division / PG-Strom Project KaiGai Kohei
> -Original Message-----
> From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Taiki Kondo
> Sent: Thursday, August 13, 2015 6:30 PM
> To: pgsql-hackers@postgresql.org
> Cc: Kaigai K
e ongoing work.
-- Original ----------
From: "Amit Langote";;
Date: Mon, Aug 31, 2015 03:14 PM
To: "My Life";
"pgsql-hackers";
Subject: Re: [HACKERS] [PROPOSAL] Table Partition
Hello,
On 2015-08-30 PM 10:42, My Life wrote:
&g
Hello,
On 2015-08-30 PM 10:42, My Life wrote:
>
> For partitioned table's scan action, and JOIN action, we implemented
> a plan node named 'PartitionExpand'. the plan node can expand the
> partitioned table scan node into a list of partitions according to
> the filter and conditions. and it can
Hi, everyone! I'd like to propose a postgres partition implementation. First, I
would show the design to everyone, and talk about it. If we think the design is
not very bad, and can be commit to the PostgreSQL baseline, then I will post
the code to the community.
(note: my english is not very go
ge-
> From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Taiki Kondo
> Sent: Thursday, August 13, 2015 6:30 PM
> To: pgsql-hackers@postgresql.org
> Cc: Kaigai Kouhei(海外 浩平); Iwaasa Akio(岩浅 晃郎)
> Subject: [HACKERS] [Proposal] Ta
Hi all,
I saw the email about the idea from KaiGai-san[1],
and I worked to implement this idea.
Now, I have implemented a part of this idea,
so I want to propose this feature.
Patch attached just shows my concept of this feature.
It works fine for EXPLAIN, but it returns wrong result for other o
25 matches
Mail list logo