some sql like ' select a from t1 intersect select a from t1 '

if t1 has large number rows but has few distinct rows

select distinct a from t1 intersect select distinct a from t1;    ― this is 
faster than origin sql

can postgres do this optimize during plan-queries?

Reply via email to