pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: Re: Question on partitioning
Date: Fri, 10 Nov 2006 09:39:16 -0800 (PST)
Message-ID: <129402.28483.qm@web31803.mail.mud.yahoo.com> (raw)
In-Reply-To: <003201c704e5$74fb5a00$b501a8c0@D1RPQZB1>

> Thanks to all who responded to my question on querying on cluster index
> names.
> I have another question.  We are considering partitioning 2 or 3 of our
> larger tables.
> Each has 12 million or more rows.  We want to partition on customer_id and
> build
> Primary key indexes on each of the children partitions which inherit column
> characteristics
> From the master table.  This would resolve any issues about queries on
> customer-id. 
>  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?

I haven't done too much partitioning yet, but this is where I would start looking first:
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html

Regards,

Richard Broersma Jr.



view thread (6+ messages)  latest in thread

Message-ID: <129402.28483.qm@web31803.mail.mud.yahoo.com>
Permalink:  ../129402.28483.qm@web31803.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/129402.28483.qm@web31803.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rabroersma@yahoo.com, msteben@autorevenue.com
  Subject: Re: Question on partitioning
  In-Reply-To: <129402.28483.qm@web31803.mail.mud.yahoo.com>
  References: <003201c704e5$74fb5a00$b501a8c0@D1RPQZB1> <129402.28483.qm@web31803.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox