Re: BUG #2342: Extremely bad performance on a specific query, compared to 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mattias Kregert" <mattias(at)kregert(dot)se>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2342: Extremely bad performance on a specific query, compared to 7.4
Date: 2006-03-20 22:12:05
Message-ID: 8210.1142892725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Mattias Kregert" <mattias(at)kregert(dot)se> writes:
> SELECT id FROM pics WHERE
> (file='3a76h3gd873kmn7ckd76' AND archived IS NULL) OR
> (file='jj38kmc983lmn2547cx0' AND archived IS NULL) OR
> ...

Could we see EXPLAIN ANALYZE results for this query from both the 7.4
and 8.1 systems? Since you haven't even told us what indexes are
available on the table, there's not a lot we can do with this report.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Donald Fraser 2006-03-20 22:41:11 No length checking for "name" input
Previous Message Tom Lane 2006-03-20 22:10:04 Re: BUG #2341: Wrong results when using index