> > 3. Partitions are RelFileNodes, but not Tables > > We allow a table to have multiple RelFileNodes, when explicitly declared > that way. > > This means we have to change > - DDL changes to allow TABLE level changes to apply to all RelFileNodes, > while PARTITION level changes to apply to only one RelFileNode > - indexes, so they can refer to more than one partition > - share locking in the executor > - changes to allow synchronous scans and buffer recycling > > There *are* other changes not mentioned here that are required for > partitioning, which although complex are less doubtful. > It can be used for global temporary tables with some modification
table defines structure and partitions defines contents for sessions. Regards Pavel Stehule > Simon Riggs > 2ndQuadrant http://www.2ndQuadrant.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
