Tom Lane <t...@sss.pgh.pa.us> writes: > Sergey Burladyan <eshkin...@gmail.com> writes: > > Oh, now problem with simple query: > > > 8.4.0 from Debian > > explain analyze select i from t where i >= 10 and i = 1; > > QUERY PLAN > > ------------------------------------------------------------------------------------ > > Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 > > loops=1) > > One-Time Filter: false > > Total runtime: 0.030 ms > > > CVS HEAD > > explain analyze select i from t where i >= 10 and i = 1; > > QUERY PLAN > > --------------------------------------------------------------------------------------------------- > > Seq Scan on t (cost=0.00..17030.00 rows=1 width=4) (actual > > time=449.651..449.651 rows=0 loops=1) > > Filter: ((i >= 10) AND (i = 1)) > > Total runtime: 449.726 ms
> Hmm, that's got nothing to do with my recent patch, because there's no > appendrel anywhere. Are you sure you are using the same > constraint_exclusion setting in both cases? Oops, of course you are right, i have constraint_exclusion = on in Debian, but constraint_exclusion = partition by default in CVS HEAD %) Thanks for help, Tom ! -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
