Re: Should I partition this table?

Kevin,

What would be the advantages of partitioning on ranges of ParentID? Each
query will touch at most one partition. I might or might not get PK indexes
one level of depth less.

I understand that I will CLUSTER these smaller tables and benefit from that.
Other than clustering, what are other advantages?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Should-I-partition-this-table-tp5811130p5811157.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.