Re: [PERFORM] fake condition causes far better plan

2005-08-23 Thread Tom Lane
=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <[EMAIL PROTECTED]> writes: > [ bad query plan ] Most of the problem is here: > -> Index Scan using muvelet_vonalkod_ny_idopont on > muvelet_vonalkod_ny ny (cost=0.00..1351.88 rows=24649 width=4) (actual > time=0.161..10.735 rows=3943 loo

[PERFORM] fake condition causes far better plan

2005-08-23 Thread Szűcs Gábor
Dear Gurus, System: Debian "Woody" 2.4.28 Version: PostgreSQL 7.4.8 I have a join which causes a better hash if I provide a "trivial" condition: WHERE m.nap > '1900-01-01'::date This is a date field with a minimum of '2005-06-21'. However, if I omit this condition from the WHERE clause, I get a