Table partitioning based on multiple criterias possible?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Table partitioning based on multiple criterias possible?
Date: 2007-09-12 08:15:28
Message-ID: 1189584928.13796.17.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2007-09-12 08:28:11 Database/Table Design for Global Country Statistics
Previous Message Kai Behncke 2007-09-12 08:08:53 Question to schema public