Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B4DF69FCB6C for ; Wed, 7 Nov 2007 19:36:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66263-05 for ; Wed, 7 Nov 2007 19:36:21 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.190]) by postgresql.org (Postfix) with ESMTP id DA5F79FCB6A for ; Wed, 7 Nov 2007 19:36:19 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so2795453mue for ; Wed, 07 Nov 2007 15:36:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=TYGQ4Z19Yx8rSRLGz0dM92EtjDHMeMLca/bFRoEgt84=; b=j5lyiyZAyRD79FWq6K/SPYHzm4VQvo4SOnLBGgEQXGtOShNtFXChcPTXnZc8OC8FeM4Cy1Z2wyVv+JDz+/IlTguqSIoM4cbnE+US6PhTJIg+y2GPvkoNPvDXrdvgKigDvSQMOjrvIAtRTz9vSSarc+nJih07AVHvhCZvdnSW3cs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MgMgx3011L/RGHd21VAbOrFYL0uJO9NWfV3zoCS6c0KOO/hYSIukUoR/nTmSh4qtlT3cPI5J+GMeqSo/IS0b9yH+ZAtoQwbe3P7YXt8cL6tx8yK2EG40CnWfISHlXrGa6m6Lz0EMT4X7j+Wcfoy3HJbW7FRBszD5XXPVhlXsHU8= Received: by 10.82.175.17 with SMTP id x17mr16189688bue.1194478576269; Wed, 07 Nov 2007 15:36:16 -0800 (PST) Received: by 10.82.118.6 with HTTP; Wed, 7 Nov 2007 15:36:16 -0800 (PST) Message-ID: <1d4e0c10711071536lcc504e6n395e90f2d823f39a@mail.gmail.com> Date: Thu, 8 Nov 2007 00:36:16 +0100 From: "Guillaume Smet" To: "Tom Lane" Subject: Re: Estimation problem with a LIKE clause containing a / Cc: pgsql-performance In-Reply-To: <11467.1194477248@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1d4e0c10711070453q214f089cpd144cbb5193d3c4f@mail.gmail.com> <17767.1194453292@sss.pgh.pa.us> <11467.1194477248@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/87 X-Sequence-Number: 27502 On 11/8/07, Tom Lane wrote: > I've applied a patch that might help you: > http://archives.postgresql.org/pgsql-committers/2007-11/msg00104.php Thanks. I'll build a RPM package tomorrow with this patch and let you know if it fixes the problem. -- Guillaume