Re: Partitioning Option? - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Partitioning Option?
Date
Msg-id 421E73E8.3060203@bigfoot.com
Whole thread Raw
In response to Re: Partitioning Option?  ("Tomeh, Husam" <htomeh@firstam.com>)
List 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


pgsql-admin by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Re: lowercase function
Next
From: Gaetano Mendola
Date:
Subject: Re: Partitioning Option?