Table partitioning based on multiple criterias possible?

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Table partitioning based on multiple criterias possible?
Дата
Msg-id 1189584928.13796.17.camel@neuromancer.home.net
обсуждение исходный текст
Ответы Re: Table partitioning based on multiple criterias possible?  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
New to Pg and wondering the extent of PG's table partitioning
capability.

I have a huge table > 18 million rows(growth rate ~8 million a week)
which I like to implement partitioning.

Initially the plan is to just partition it by date. eg: 1 partition per
month.

Now, I'm thinking if it's possible to also partition them by
product/items.

is it possible to do multilevel partitioning sort of like

if month = July then go to July Parition
    if Product = Shampoo then go to shampoo partition
        elif Product = Soap then go to soap partition

something like that..

Thanks


В списке pgsql-general по дате отправления:

Предыдущее
От: "Kai Behncke"
Дата:
Сообщение: Question to schema public
Следующее
От: Stefan Schwarzer
Дата:
Сообщение: Database/Table Design for Global Country Statistics