Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8B8C39F9357 for ; Sat, 16 Dec 2006 16:30:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 72730-09 for ; Sat, 16 Dec 2006 16:30:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp4.poczta.interia.pl (smtp10.poczta.interia.pl [80.48.65.10]) by postgresql.org (Postfix) with ESMTP id 9BDEA9F9FB2 for ; Sat, 16 Dec 2006 16:30:21 -0400 (AST) Received: by smtp4.poczta.interia.pl (INTERIA.PL, from userid 502) id 510B7273EC7; Sat, 16 Dec 2006 21:30:20 +0100 (CET) Received: from poczta.interia.pl (mi01.poczta.interia.pl [10.217.12.1]) by smtp4.poczta.interia.pl (INTERIA.PL) with ESMTP id EB6AD273E9B; Sat, 16 Dec 2006 21:30:19 +0100 (CET) Received: by poczta.interia.pl (INTERIA.PL, from userid 502) id 5B6EF270087; Sat, 16 Dec 2006 21:30:19 +0100 (CET) Received: from [192.168.1.101] (nomad.net.autocom.pl [213.134.176.226]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by www.poczta.fm (INTERIA.PL) with ESMTP id 2FEEB270096; Sat, 16 Dec 2006 21:30:13 +0100 (CET) Message-ID: <4584574B.9080100@poczta.fm> Date: Sat, 16 Dec 2006 21:30:03 +0100 From: jamcito User-Agent: Thunderbird 1.5.0.8 (X11/20061203) MIME-Version: 1.0 To: Ireneusz Pluta Cc: pgsql-performance@postgresql.org Subject: Re: partition text/varchar check problem References: <458402D4.7080500@poczta.fm> <4584540D.2080208@wp.pl> In-Reply-To: <4584540D.2080208@wp.pl> Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-EMID: ce746138 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/445 X-Sequence-Number: 22501 Ireneusz Pluta wrote: > Can you show what you get from: > EXPLAIN SELECT * FROM data WHERE name LIKE 'a%' > > ? > > Irek. I get: QUERY PLAN ------------------------------------------------------------------------ Result (cost=0.00..24.42 rows=8 width=48) -> Append (cost=0.00..24.42 rows=8 width=48) -> Seq Scan on data (cost=0.00..22.38 rows=5 width=48) Filter: ((name)::text ~~ 'a%'::text) -> Seq Scan on data_a data (cost=0.00..1.02 rows=2 width=23) Filter: ((name)::text ~~ 'a%'::text) -> Seq Scan on data_b data (cost=0.00..1.02 rows=1 width=23) Filter: ((name)::text ~~ 'a%'::text) (8 rows) Both partition tables are scanned. Best, jamcito ---------------------------------------------------------------------- smieszne, muzyka, pilka, sexy, kibice, kino, ciekawe, extreme, kabaret http://link.interia.pl/f19d4 - najlepsze filmy w intermecie