Ow Mun Heng wrote:
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.
OK
Initially the plan is to just partition it by date. eg: 1 partition per
month.
Fair enough - do you do a lot of searching by date?
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
Well, I suppose you could partition over (month,product) but you
probably don't want to. Sounds fiddly to manage.
Have you verified that performance will be a problem without this?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
