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

Re: Partitioning Option?

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Partitioning Option?
Date: 2005-02-23 18:54:50
Message-ID: C45835824D00A844BBD0F032D5CDED9212FC75@pisgana01sxch01.ana.firstamdata.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks Josh, I'll check out the namespace concept.

(I was referring to object partitioning. For instance, if I have a huge
table with US counties as my partition key, I could create partitions
within the same table based on the partition key (a US county for
example). When querying, the engine will access the partition instead of
the whole table to get the result set. This is provided in Oracle DB EE.
So, I was wondering whether I can do similar thing in PostgreSQL since
we're exploring PostgreSQL)

--
  Husam

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com] 
Sent: Wednesday, February 23, 2005 10:50 AM
To: Tomeh, Husam
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Partitioning Option?

Tomeh, Husam wrote:

>Does PostgreSQL support/allow "partitioning" of objects like tables and

>indexes, like Oracle does?
>  
>
We support tablespaces but not table partitioning. You can get around
this by using namespaces and unions however.

Sincerely,

Joshua D. Drake


>I have searched the docs, but haven't found anything to partitioning.
>
>Thanks,
>
>--
>  Husam
>**********************************************************************
>This message contains confidential information intended only for the 
>use of the addressee(s) named above and may contain information that is

>legally privileged.  If you are not the addressee, or the person 
>responsible for delivering it to the addressee, you are hereby notified

>that reading, disseminating, distributing or copying this message is 
>strictly prohibited.  If you have received this message by mistake, 
>please immediately notify us by replying to the message and delete the 
>original message immediately thereafter.
>
>Thank you.                                       FADLD Tag
>**********************************************************************
>
>
>---------------------------(end of 
>broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to 
>majordomo(at)postgresql(dot)org
>  
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-02-23 19:12:26
Subject: Re: Partitioning Option?
Previous:From: Joshua D. DrakeDate: 2005-02-23 18:49:42
Subject: Re: Partitioning Option?

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