| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
| Cc: | Mark Steben <msteben(at)autorevenue(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Question on partitioning |
| Date: | 2006-11-10 18:35:46 |
| Message-ID: | 1163183746.6530.12.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> > My question is this: How would I handle a query that queries
> > On another Non-partitioned column, say, ENTRY_DATE? Could I design an index
> > On the master table that would reference ENTRY-DATE across partitions or
> > will
> > I need to build indexes and queries on each partition?
Indexes yes, queries no. You use a check constraint on the child tables
to allow the planner to determine which partitions will be used in a
particular query.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Burbello | 2006-11-10 18:57:42 | Re: Use Jobs |
| Previous Message | Richard Broersma Jr | 2006-11-10 17:39:16 | Re: Question on partitioning |