Re: Storage Model for Partitioning - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Storage Model for Partitioning
Date
Msg-id 162867790801110259v7fc706f5l6966815df380f921@mail.gmail.com
Whole thread Raw
In response to Storage Model for Partitioning  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
>
> 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
>


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Storage Model for Partitioning
Next
From: Richard Huxton
Date:
Subject: Re: Storage Model for Partitioning