I am trying to apply partitioning process to some large tables on my Postgresql database, I have read the documentation and many articles about that and could not found an answer to this question.
If I use the range partitioning on for example a Date field, is it necessary to do queries with this field in order to get the benefits of the partition process or can I have this even if I do queries using other fields not included in partitioning fields condition ?
Thanks