Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 326C19FCB6D for ; Wed, 7 Nov 2007 19:33:05 -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-02 for ; Wed, 7 Nov 2007 19:32:59 -0400 (AST) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.188]) by postgresql.org (Postfix) with ESMTP id 5E1119FCB6C for ; Wed, 7 Nov 2007 19:32:59 -0400 (AST) Received: by fk-out-0910.google.com with SMTP id b27so2544069fka for ; Wed, 07 Nov 2007 15:32:56 -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=KNuRJUC6ZGEASe4a/eBGLk8M6i0z70OJoozE8Ewjhig=; b=oxTchGpYfnV+LbwB0QGj7vMG3poZQ8sQap1hLsJFoo1+yih8iGSUengoPo5/lZg0oTJa5TWQNLyN5kUNJEww62k0UeqUmD4bKkgVGtHoPeth5lzruGOzNqBgoSVz8wOxCJXs6Xh4qjiwJu6IQcTjcnSzcj+dgPOnjKeMBbs+9Mc= 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=uhi8tR16h/18AARsMeL2ORbOwn0d5WcySEMKBMucmhf4/O1cNbycdrZi3Xxj4mEhaYlp5DkV7DXMBEltAwEHSog8KRDqxV94dcVoqYe7Q/jCX8yk7PZYN89QO0ZXSvqN4Itc4wrkAhqV1LAnhulLecK4vwoaDQc7032mAZyY2sY= Received: by 10.82.107.15 with SMTP id f15mr16223342buc.1194478375887; Wed, 07 Nov 2007 15:32:55 -0800 (PST) Received: by 10.82.118.6 with HTTP; Wed, 7 Nov 2007 15:32:55 -0800 (PST) Message-ID: <1d4e0c10711071532oc6ed9afq1cbf1b2e69ed49fd@mail.gmail.com> Date: Thu, 8 Nov 2007 00:32:55 +0100 From: "Guillaume Smet" To: "Tom Lane" Subject: Re: Estimation problem with a LIKE clause containing a / Cc: pgsql-performance In-Reply-To: <18180.1194454729@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> <1d4e0c10711070852hfc8aaf2o6eb0cdace2efc9b5@mail.gmail.com> <18180.1194454729@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/86 X-Sequence-Number: 27501 On 11/7/07, Tom Lane wrote: > I wanted the locale (lc_collate), not the encoding. fr_FR.UTF-8 > That would optimize this particular query and probably pessimize > a lot of others. Sure but there aren't a lot of queries based on the ancestors field and if they are a bit slower, it's not a problem. However having a query taking forever is not acceptable as the content management app is unaccessible. So it can be an acceptable solution in this case, even if not perfect. -- Guillaume