Bill, Regarding "SELECT performance improve nearly linerally to the number of partitions," - can you elaborate why? If I split my table into several partitions, even the index depth may stay the same, because the PK is narrow, it only consists of 2 4-byte integers. My selects are distributed more or less evenly, so we really like your suggestion to split on ParentID%SomeNumber, thank you! At this time we would rather not introduce bugs related to cache invalidation. Although we do need to read data fast, we do not want stale data, and we cannot afford any bugs in this application. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Should-I-partition-this-table-tp5811130p5811141.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
