Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 289DB9F96CB
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  9 Nov 2007 16:57:36 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 15110-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  9 Nov 2007 16:57:18 -0400 (AST)
Received: from fk-out-0910.google.com (fk-out-0910.google.com
 [209.85.128.191])
	by postgresql.org (Postfix) with ESMTP id BFF129F9277
	for <pgsql-performance@postgresql.org>;
	Fri,  9 Nov 2007 16:57:30 -0400 (AST)
Received: by fk-out-0910.google.com with SMTP id b27so666868fka
	for <pgsql-performance@postgresql.org>;
	Fri, 09 Nov 2007 12:57:27 -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=gqCOYhnZJ/dZJquEtQ7Xm0YFE+TC9RJo5P6o7tWM2xg=;
	b=PfVDkIQycACRNdgM+ANZNQ30IS0yZd+dfuRcarnG5+MBvDLa/Paq98w1rwv597Ou/Se2v7RXq1mBDay7uLLrcU1twQjii2P+YYNyrsNZKMOBsiJo9MNFadPIY/nnucsKDUMN4XVRWFQw6C7pREnvoe32a9e2ND/IFeM26dcaJOY=
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=Y1wZIC61RNIhhvf7rGSwr5fPxUoHg3yUQLG8Sg6pDzb9M0S4NL0ry7Rk5AYbQZaQcmR4VbT+lsgzI5K1Vb0w4dcZHfBLwxleHbviJ3WQS/CLqt/8Lgk7yRUgk2HQwNiDYqLTOrn+EBOsIPMRilKBQTGuOUTggzjCN5WvX2xMIEI=
Received: by 10.82.155.10 with SMTP id c10mr4835589bue.1194641847496;
	Fri, 09 Nov 2007 12:57:27 -0800 (PST)
Received: by 10.82.118.6 with HTTP; Fri, 9 Nov 2007 12:57:27 -0800 (PST)
Message-ID: <1d4e0c10711091257w401c95f4s5f63ae32daecd14e@mail.gmail.com>
Date: Fri, 9 Nov 2007 21:57:27 +0100
From: "Guillaume Smet" <guillaume.smet@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: [HACKERS] Estimation problem with a LIKE clause containing a /
Cc: "Gregory Stark" <stark@enterprisedb.com>,
	pgsql-performance <pgsql-performance@postgresql.org>,
	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/158
X-Sequence-Number: 27573

Tom,

Just to confirm you that your last commit fixed the problem:

lbo=# explain analyze select * from cms_items where ancestors LIKE '1062/%';
                                                  QUERY PLAN
---------------------------------------------------------------------------------------------------------------
 Seq Scan on cms_items  (cost=0.00..688.26 rows=*9097* width=103)
(actual time=0.011..22.605 rows=11326 loops=1)
   Filter: ((ancestors)::text ~~ '1062/%'::text)
 Total runtime: 30.022 ms
(3 rows)

Thanks for your time.

--
Guillaume