Table partitioning based on multiple criterias possible? - Mailing list pgsql-general

From Ow Mun Heng
Subject Table partitioning based on multiple criterias possible?
Date
Msg-id 1189584928.13796.17.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Table partitioning based on multiple criterias possible?
List 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 by date:

Previous
From: "Kai Behncke"
Date:
Subject: Question to schema public
Next
From: Stefan Schwarzer
Date:
Subject: Database/Table Design for Global Country Statistics