Skip site navigation (1) Skip section navigation (2)

Re: partition text/varchar check problem

From: jamcito <jamcito(at)poczta(dot)fm>
To: Ireneusz Pluta <ipluta(at)wp(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: partition text/varchar check problem
Date: 2006-12-16 20:30:03
Message-ID: 4584574B.9080100@poczta.fm (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2006-12-16 20:34:41
Subject: Re: partition text/varchar check problem
Previous:From: Ireneusz PlutaDate: 2006-12-16 20:16:13
Subject: Re: partition text/varchar check problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group