| From: | John Lister <john(dot)lister-ps(at)kickstone(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Partitioning by letter question |
| Date: | 2010-01-29 22:24:34 |
| Message-ID: | 4B636022.90804@kickstone.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi, I was wondering if this was possible. I'm trying to partition a
table, which is straightforward enough thanks to the great
documentation, but i have a question:
If I partition using something like a product_id for example and have
check constraints such as (id>=1000 and id<2000) then everything is fine
and the planner correctly uses the right subset of the tables. However I
would like to partition by the first letter and using something like
this substr(word,1,1)='a' is ignored by the planner. From reading the
docs I understand that complicated check constraints are ignored, but
this doesn't seem overly complicated.
Am i doing something wrong or is there another better way to do this
Thanks
John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-01-29 23:50:31 | Re: Partitioning by letter question |
| Previous Message | Guillaume Lelarge | 2010-01-27 14:19:00 | Re: rename primary key |