Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3AEAE9F95D2 for ; Fri, 9 Nov 2007 12:40:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 30711-03 for ; Fri, 9 Nov 2007 12:39:56 -0400 (AST) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.189]) by postgresql.org (Postfix) with ESMTP id 2C2469F94A0 for ; Fri, 9 Nov 2007 12:39:55 -0400 (AST) Received: by fk-out-0910.google.com with SMTP id b27so581123fka for ; Fri, 09 Nov 2007 08:39:53 -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=VzI9TdTKFSgrVyfJBvea1eZASc2dpAXkjg5ukag0we8=; b=YncT7AMixdDA4xjziZUXAm0hsgipzvADdirkn7EFO/JGwJUlm0gQNyKlAzLqB+e6sV/GpY9cA64cIn38F0j2nCUVaNa8dRMilu3Fon+9xjBEM0qGWKTlL4TtHBFP7J4ydfnxPHG9FSJIq1vPY3wTa5rrYxafniOquvUEnQFicZE= 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=ZhuyZDXt98qN7ABQ5NLaBnehlcjcxa+XsNSYcwSGyWXLktB3b0ufovX1mQLq6DjtpmkxzNZyTgySUCgICI4TXa9PAVal1vikUbf5BELFcL4rw7haKNt0LdteVGzjgkQ1njeXKVpqovFynQf0oc6OghdrajZhO6s9r8Xei8SjiRE= Received: by 10.82.154.12 with SMTP id b12mr4369122bue.1194626392065; Fri, 09 Nov 2007 08:39:52 -0800 (PST) Received: by 10.82.118.6 with HTTP; Fri, 9 Nov 2007 08:39:51 -0800 (PST) Message-ID: <1d4e0c10711090839v288a0614j174bdceadfc6b5b2@mail.gmail.com> Date: Fri, 9 Nov 2007 17:39:51 +0100 From: "Guillaume Smet" To: "Tom Lane" Subject: Re: [HACKERS] Estimation problem with a LIKE clause containing a / Cc: "Gregory Stark" , pgsql-performance , pgsql-hackers@postgresql.org In-Reply-To: <11342.1194626025@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> <1d4e0c10711080208n6c9875b4tf5882da3ced18532@mail.gmail.com> <27405.1194542548@sss.pgh.pa.us> <87prykpc3q.fsf@oxford.xeocode.com> <25287.1194568820@sss.pgh.pa.us> <28300.1194574114@sss.pgh.pa.us> <87hcjvpydn.fsf@oxford.xeocode.com> <11342.1194626025@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/141 X-Sequence-Number: 27556 On Nov 9, 2007 5:33 PM, Tom Lane wrote: > he's got no MCVs, presumably because the field > is unique. It is. The ancestors field contains the current folder itself so the id of the folder (which is the primary key) is in it. -- Guillaume