From: jamcito <jamcito@poczta.fm>
To: Ireneusz Pluta <ipluta@wp.pl>
Cc: pgsql-performance@postgresql.org
Subject: Re: partition text/varchar check problem
Date: Sat, 16 Dec 2006 21:30:03 +0100
Message-ID: <4584574B.9080100@poczta.fm> (raw)
In-Reply-To: <4584540D.2080208@wp.pl>
References: <458402D4.7080500@poczta.fm>
<4584540D.2080208@wp.pl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jamcito@poczta.fm, ipluta@wp.pl
Subject: Re: partition text/varchar check problem
In-Reply-To: <4584574B.9080100@poczta.fm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox