Re: One Partition by list is always chosen by planner - Mailing list pgsql-general

yes it is

show constraint_exclusion
partition

and if I explain the same query with an other filter

explain select * from wiki_data_part where category='fr'

| Append  (cost=0.00..14010.76 rows=291609 width=48)
                                                                                 
 
|   ->  Seq Scan on wiki_data_part_f  (cost=0.00..9975.04 rows=291339
width=48)
           
 
|         Filter: ((category)::text = 'fr'::text)
                                                                                 
 
|   ->  Seq Scan on wiki_data_part_s  (cost=0.00..4035.72 rows=270 width=50)
                                                                                 
 
|         Filter: ((category)::text = 'fr'::text)    

wiki_data_part_s is always chosen in the plan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html