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