Re: What needs to be done for real Partitioning?

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: What needs to be done for real Partitioning?
Дата
Msg-id
op.snwsl7v7th1vuj@localhost
Ответ на
Список
Дерево обсуждения
Re: What needs to be done for real Partitioning? "Roger Hand" <RHand@kailea.com>

> tableoid would accomplish that already, assuming that the "partitioned
> table" is effectively a view on separate physical tables.
>
> 			regards, tom lane

	Very good.

	Also note the possibility to mark a partition READ ONLY. Or even a table.
	It does not seem very useful but just think that for instance the "1999",  
"2000" ... "2004" partitions of a big archive probably never change.  
READLONY means we're sure they never change, thus no need to backup them  
every time. Keeping the example of some DB arranged by years / current  
year / current month, Just backup the "current month" part every day and  
the "current year" every month when you switch partitions.
	This could be achieved also by storing the time of last modification of a  
table somewhere.

В списке pgsql-performance по дате отправления
От: Steve Atkins
Дата:
От: Tom Lane
Дата:
FAQ