Re: Storage Model for Partitioning

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Storage Model for Partitioning
Дата
Msg-id 162867790801110259v7fc706f5l6966815df380f921@mail.gmail.com
обсуждение исходный текст
Ответ на Storage Model for Partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Storage Model for Partitioning
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Storage Model for Partitioning