X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 91915DB7AD for ; Mon, 14 Nov 2005 21:29:27 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25298-01 for ; Tue, 15 Nov 2005 01:29:22 +0000 (GMT) X-Greylist: delayed 00:10:32.702321 by SQLgrey- Received: from mail-ihug.icp-qv1-irony3.iinet.net.au (ihug-mail.icp-qv1-irony3.iinet.net.au [203.59.1.197]) by svr1.postgresql.org (Postfix) with ESMTP id 9212BDB77F for ; Mon, 14 Nov 2005 21:29:23 -0400 (AST) Received: from 203-214-116-121.dyn.iinet.net.au (HELO [192.168.1.21]) ([203.214.116.121]) by mail-ihug.icp-qv1-irony3.iinet.net.au with ESMTP; 15 Nov 2005 09:18:49 +0800 X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAQAAA+k= Message-ID: <43793778.7040006@linuxgamers.net> Date: Tue, 15 Nov 2005 12:18:48 +1100 From: Leigh Dyer User-Agent: Thunderbird 1.5 (X11/20051025) MIME-Version: 1.0 To: Postgres-performance Subject: Re: Help speeding up delete References: <43790A99.9050603@noao.edu> <4162.1132011763@sss.pgh.pa.us> <43792523.5090003@noao.edu> In-Reply-To: <43792523.5090003@noao.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/382 X-Sequence-Number: 15639 Steve Wampler wrote: > > Is the performance behavior that we're experiencing a known > problem with 7.2 that has been addressed in 7.4? Or will the > upgrade fix other problems while leaving this one? I'm pretty sure that in versions earlier than 7.4, IN clauses that use a subquery will always use a seqscan, regardless of what indexes are available. If you try an IN using explicit values though, it should use the index. Thanks Leigh