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 src/backen
join is cheaper than semi join, so you can see
the planner chose the hash join rather than semi join.
--
Jerry Yu
https://github.com/scarbrofair
-- Original --
From: "Robert Haas";;
Date: Fri, Jul 22, 2016 00:23 AM
To: "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 wi
obert Haas";;
Date: Fri, Feb 26, 2016 07:33 PM
To: "Armor";
Cc: "Tom Lane"; "Euler Taveira";
"Alvaro Herrera";
"pgsql-hackers";
Subject: Re: [HACKERS] get current log file
On Fri, Feb 26, 2016 at 8:31 AM, Armor wrote:
> I think I
last_syslogger_file_time. However, I think this case is a corner case.
--
Jerry Yu
https://github.com/scarbrofair
-- Original --
From: "Tom Lane";;
Date: Thu, Feb 25, 2016 10:47 PM
To: "Robert Haas";
Cc: "Euler Ta
.
--
Jerry Yu
-- Original --
From: "Alvaro Herrera";;
Date: Tue, Feb 2, 2016 06:30 PM
To: "Armor";
Cc: "pgsql-hackers";
Subject: Re: [HACKERS] get current log file
Armor wrote:
> Hello,
>
>
&g
Sorry， forgot forwarding the mail to the mail list.
Please put some comments.
--
Jerry Yu
https://github.com/scarbrofair
-- Original --
From: "Armor";;
Date: Tue, Feb 2, 2016 09:22 PM
To: "Alvaro Herrera";
Subject:
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
