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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend