Re: [PERFORM] Poor performance with queries using clause: sth IN (...)

2007-05-09 Thread Gregory Stark
> AND '' IN ('', upper(b.nazwisko)) > AND '' IN ('', upper(b.imie)) > AND '7804485' IN ('', b.pesel) > AND '' IN ('', upper(trim(b.dowseria))) > AND '' IN ('', b.dowosnr) > AND 0 IN (0, b.typkred) > AND k.datazwrot IS NULL; Hum, interesting. Most of the work Postgres does with IN clauses i

[PERFORM] Poor performance with queries using clause: sth IN (...)

2007-05-09 Thread Andrzej Zawadzki
That's email from my friend. Any hint? Original Message Subject: bug Date: Wed, 09 May 2007 15:03:00 +0200 From: Michal Postupalski To: Andrzej Zawadzki We've just changed our database from 8.1 to 8.2 and we are grief-stricken about very poor performance with queries using claus