On Fri, 29 Nov 2019 15:38:53 +0100 Goke Aruna <goksie@gmail.com> wrote:
> Thanks Jean-Yves / Steven, > am using V12.
Depending on the way you mostly use your columns, you can also do the opposite: store date/timestamp into "pieces" in different columns (century, month, day, hours, minutes, seconds, milliseconds, time zone shift) and reconstitute a whole date/ts into an auto-generated column.
Sometimes, you have to break the rules, especially with a large number of rows, because pre-calculation is way better than post in this case.
BTW, don't leave us dry, share your progress and results *<;-)
Jean-Yves
Please do not advise the use of inheritance/trigger based partitioning anymore, especially on PG12. Partitioning is now part of core and is much more easily managed that way