Hi I found some crazy queries in one customer application. These queries are stupid, but it was surprise for me so there are not some simple optimization
create table foo(a int); insert into foo select generate_series(1,100000); analyze foo; explain select * from foo where a <> a; It does full scan of foo, although it should be replaced by false in planner time. Same issue is a expression a = a .. can be replaced by true Regards Pavel
