Re: Performance Killer 'IN' ? - Mailing list pgsql-general

From Marko Kreen
Subject Re: Performance Killer 'IN' ?
Date
Msg-id e51f66da0603310727o75f707f2uab7ae1c6f1720aaa@mail.gmail.com
Whole thread Raw
In response to Re: Performance Killer 'IN' ?  (Kai Hessing <kai.hessing@hobsons.de>)
Responses Re: Performance Killer 'IN' ?  (Kai Hessing <kai.hessing@hobsons.de>)
List pgsql-general
On 3/31/06, Kai Hessing <kai.hessing@hobsons.de> wrote:
> The second one (UPDATE xyz WHERE id IN (xyz1, xyz2, ....) AND
> status>-1;) returns:
> ------------------
> Seq Scan on phon  (cost=0.00..1573304.58 rows=105931 width=148) (actual
> time=369563.565..369563.565 rows=0 loops=1)

Just a shot in the dark: does the plan stay the same,
when you remove the ' AND status > -1' ?

--
marko

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: [Slightly OT] data model books/resources?
Next
From: Tom Lane
Date:
Subject: Re: Performance Killer 'IN' ?