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

Re: partition text/varchar check problem

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: jamcito <jamcito(at)poczta(dot)fm>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: partition text/varchar check problem
Date: 2006-12-16 20:16:13
Message-ID: 4584540D.2080208@wp.pl (view raw or flat)
Thread:
Lists: pgsql-performance
jamcito napisaƂ(a):
> /*********************************************/
> SET constraint_exclusion=on;
> SET
>
> SHOW constraint_exclusion;
>  constraint_exclusion
> ----------------------
>  on
> (1 row)
>
> EXPLAIN SELECT * FROM data WHERE name = 'aaa';
>                                QUERY PLAN
> ------------------------------------------------------------------------
>  Result  (cost=0.00..24.42 rows=7 width=48)
>    ->  Append  (cost=0.00..24.42 rows=7 width=48)
>          ->  Seq Scan on data  (cost=0.00..22.38 rows=5 width=48)
>                Filter: ((name)::text = 'aaa'::text)
>          ->  Seq Scan on data_a data  (cost=0.00..1.02 rows=1 width=23)
>                Filter: ((name)::text = 'aaa'::text)
>          ->  Seq Scan on data_b data  (cost=0.00..1.02 rows=1 width=23)
>                Filter: ((name)::text = 'aaa'::text)
> (8 rows)
>   
Can you show what you get from:
EXPLAIN SELECT * FROM data WHERE name LIKE 'a%'

?

Irek.


In response to

Responses

pgsql-performance by date

Next:From: jamcitoDate: 2006-12-16 20:30:03
Subject: Re: partition text/varchar check problem
Previous:From: jamcitoDate: 2006-12-16 18:19:37
Subject: Re: partition text/varchar check problem -- solved

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