Re: [PERFORM] mysterious difference in speed when combining two queries with OR

loops=1) Filter: ((parent = 45) AND (pbar = 0)) -> Materialize (cost=192.62..269.24 rows=7662 width=0) (actual time=0.014..21.930 rows=7662 loops=2) -> Seq Scan on timecard (co

[PERFORM] mysterious difference in speed when combining two queries with OR

should say that this is on postgresql 7.4.16 (debian stable). Can query B be rewritten so that it would execute faster? TIA -- Hans Ekbrand (http://sociologi.cjb.net) <[EMAIL PROTECTED]> GPG Fingerprint: 1408 C8D5 1E7D 4C9C C27E 014F 7C2C 872A 7050 614E signature.asc Description: D