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
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:
>
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
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
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
.
--
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>
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: "
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