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

Re: Partitioning Option?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Subject: Re: Partitioning Option?
Date: 2005-02-25 00:40:08
Message-ID: 421E73E8.3060203@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
Tomeh, Husam wrote:
> 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)

Look on the performance list my post: "horizontal partition".


Regards
Gaetano Mendola


In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2005-02-25 00:44:38
Subject: Re: Partitioning Option?
Previous:From: Gaetano MendolaDate: 2005-02-25 00:39:08
Subject: Re: Partitioning Option?

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