Re: Performance Killer 'IN' ?

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: "Kai Hessing" <kai(dot)hessing(at)hobsons(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance Killer 'IN' ?
Date: 2006-03-31 15:27:32
Message-ID: e51f66da0603310727o75f707f2uab7ae1c6f1720aaa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/31/06, Kai Hessing <kai(dot)hessing(at)hobsons(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-31 15:45:39 Re: Performance Killer 'IN' ?
Previous Message Robert Treat 2006-03-31 15:19:03 Re: [Slightly OT] data model books/resources?