On Tue, 2023-03-14 at 19:33 -0400, James Robertson wrote: > Laurenz your solution is how I thought I would work around my (lack of) > understanding > of partitioning. (nested partitions). > I was hesitant because I didn't know what sort of performance problems I > would create for myself. > > [...] more performance [...]
If you are thinking of subpartitioning primarily in terms of boosting performance, you should know that you only get performance benefits from partitioning with very special queries that effectively have to be designed together with the partitioning strategy. Other statements typically become somewhat slower through partitioning. So it is really impossible to discuss performance benefits without knowing the exact query. It may be best if you build a play database with realistic amounts of test data and use EXPLAIN and EXPLAIN (ANALYZE) to see the effects that partitioning has on your queries. Yours, Laurenz Albe
