[HACKERS] propose to pushdown qual into EXCEPT

2016-12-23 Thread Armor
Recently, we find PG fails to generate an effective plan for following SQL: select * from (select * from table1 execpt select * from table2) as foo where foo.a > 0; Because PG does not pushdown qual to the none of the subquery. And I check the source code, find some comments in

Re: [HACKERS] One question about transformation ANY Sublinks into joins

2016-07-23 Thread Armor
2, 2016 00:23 AM To: "Armor"<yupengst...@qq.com>; Cc: "pgsql-hackers"<pgsql-hackers@postgresql.org>; Subject: Re: [HACKERS] One question about transformation ANY Sublinks into joins On Sun, Jul 17, 2016 at 5:33 AM, Armor <yupengst...@qq.com> wrote: >

[HACKERS] One question about transformation ANY Sublinks into joins

2016-07-17 Thread Armor
Hi I run a simple SQL with latest PG?? postgres=# explain select * from t1 where id1 in (select id2 from t2 where c1=c2); QUERY PLAN Seq Scan on t1 (cost=0.00..43291.83 rows=1130

Re: [HACKERS] get current log file

2016-02-29 Thread Armor
obert Haas";<robertmh...@gmail.com>; Date: Fri, Feb 26, 2016 07:33 PM To: "Armor"<yupengst...@qq.com>; Cc: "Tom Lane"<t...@sss.pgh.pa.us>; "Euler Taveira"<eu...@timbira.com.br>; "Alvaro Herrera"<alvhe...@2ndquadrant.com&g

Re: [HACKERS] get current log file

2016-02-26 Thread Armor
uot;<robertmh...@gmail.com>; Cc: "Euler Taveira"<eu...@timbira.com.br>; "Armor"<yupengst...@qq.com>; "Alvaro Herrera"<alvhe...@2ndquadrant.com>; "Pgsql Hackers"<pgsql-hackers@postgresql.org>; Subject: Re: [HACKERS] get c

Re: [HACKERS] get current log file

2016-02-24 Thread Armor
. -- Jerry Yu -- Original -- From: "Alvaro Herrera";<alvhe...@2ndquadrant.com>; Date: Tue, Feb 2, 2016 06:30 PM To: "Armor"<yupengst...@qq.com>; Cc: "pgsql-hackers"<pgsql-hackers@postgresql.org>

Fw: Re: [HACKERS] get current log file

2016-02-24 Thread Armor
Sorry´╝î forgot forwarding the mail to the mail list. Please put some comments. -- Jerry Yu https://github.com/scarbrofair -- Original -- From: "Armor";<yupengst...@qq.com>; Date: Tue, Feb 2, 2016 09:22 PM To: "

[HACKERS] get current log file

2016-02-02 Thread Armor
Hello, I find there is a new feature about getting current log file name on the TODO list (for detail please check http://www.postgresql.org/message-id/pine.gso.4.64.0811101325260.9...@westnet.com). On the other side, we finish a ticket to this requirement for our customer. If the PG