X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 33EB69DC809 for ; Wed, 11 Jan 2006 04:00:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13324-10 for ; Wed, 11 Jan 2006 04:00:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from opteron.random (217-133-42-200.b2b.tiscali.it [217.133.42.200]) by postgresql.org (Postfix) with ESMTP id E194C9DC865 for ; Wed, 11 Jan 2006 03:59:57 -0400 (AST) Received: by opteron.random (Postfix, from userid 500) id E9C6E1C18DB; Wed, 11 Jan 2006 08:59:56 +0100 (CET) Date: Wed, 11 Jan 2006 08:59:56 +0100 From: Andrea Arcangeli To: Tom Lane Cc: Greg Stark , pgsql-performance@postgresql.org Subject: Re: NOT LIKE much faster than LIKE? Message-ID: <20060111075956.GU15897@opteron.random> References: <20060110014447.GB18474@opteron.random> <24021.1136858688@sss.pgh.pa.us> <20060110022303.GA20168@opteron.random> <24372.1136861684@sss.pgh.pa.us> <20060110034721.GC20168@opteron.random> <87y81oyv6x.fsf@stark.xeocode.com> <20060110152720.GL15897@opteron.random> <152.1136908013@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <152.1136908013@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/103 X-Sequence-Number: 16581 On Tue, Jan 10, 2006 at 10:46:53AM -0500, Tom Lane wrote: > Not with that data, but maybe if you increased the statistics target for > the column to 100 or so, you'd catch enough values to get reasonable > results. Sorry, I'm not expert with postgresql, could you tell me how to increase the statistic target? In another email you said you applied a patch to CVS, please let me know if you've anything to test for me, and I'll gladly test it immediately (I've a sandbox so it's ok even if it corrupts the db ;). Thanks!