Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 476699FCB8B for ; Thu, 8 Nov 2007 11:29:48 -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 75823-06-2 for ; Thu, 8 Nov 2007 11:29:38 -0400 (AST) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.190]) by postgresql.org (Postfix) with ESMTP id B96E39FCB86 for ; Thu, 8 Nov 2007 11:29:36 -0400 (AST) Received: by fk-out-0910.google.com with SMTP id b27so192667fka for ; Thu, 08 Nov 2007 07:29:34 -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=2bQR8EdbbzWqG+2BihRt6OYXbn6gnzKlyNp6TsQFflA=; b=gJOfkPlfNDTsCWOQ9mHlnBNb9H7HJtnmR4zvOQtf7Fi1Sa+bSnrsLQZbYTKuGK3iIWrtoFygzrUuvi0JD6oiaLUvT8zQRHV1jRc80ALy+NoVAbYBjeeXs2GQH+iejJOfsiniS1avE2vcvaU7N1ybJZrPcENMDAKV9R1Sy6b4L9g= 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=ESayKTDffx4bgUC7v0y288vahhHFHCynUdXEZBhXPPQh3LmZyc45oTOQ+IWym7TAeMua5nDTvVU77kzn+UBINTo/NPSzlTI7rKDwOOH8QMXUvW64MT/6BXPVHQZUPHODNh1IESkUCWe+p2H9uEMhmpi/LIn3TLf8GQu975N/Na8= Received: by 10.82.181.10 with SMTP id d10mr505604buf.1194535774555; Thu, 08 Nov 2007 07:29:34 -0800 (PST) Received: by 10.82.118.6 with HTTP; Thu, 8 Nov 2007 07:29:34 -0800 (PST) Message-ID: <1d4e0c10711080729y5f3eda23hfb643ee189d6e29b@mail.gmail.com> Date: Thu, 8 Nov 2007 16:29:34 +0100 From: "Guillaume Smet" To: "Tom Lane" Subject: Re: Estimation problem with a LIKE clause containing a / Cc: pgsql-performance In-Reply-To: <24220.1194534069@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> <24220.1194534069@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/103 X-Sequence-Number: 27518 On Nov 8, 2007 4:01 PM, Tom Lane wrote: > Hmm, can we see the pg_stats row for the ancestors column? Sure: public | cms_items | ancestors | 0 | 32 | -1 | | | {10011/10010/10009/10018/2554055/,10011/10010/84022/23372040/,10011/2233043/2233042/2233041/,10011/3985097/5020039/,10011/872018/13335056/13333051/,1062/22304709/22304714/,1062/2489/2492/27861901/,1062/2527/2530/29658392/,1062/2698/2705/6014040/,1062/52354/52355/255038/255037/,9846852/} | -0.151713 I can provide the data if needed, there's nothing confidential in them. -- Guillaume