only create time partitions if needed

[seanzechman]

Hello - This is in reference to this commit to only create partitions if needed -

https://github.com/cybertec-postgresql/pgwatch/pull/1127/changes#diff-f5f4e501b3dcf10eb5a1430ba83cec86dd522abc72930f0ff353d0671e213dea

Can I use this function change in version 4.1 or do I need the updated pgwatch collector as well? I ask this because I see there is more in the commit then the sql change, so just curious.

Background - We have several isolated pgwatch environments and of them has >100 monitored targets with near full metric collection footprint. Every restart we are getting ~40k new subpartitions created. In our sandbox we have subpartitions created all the way for 2040 :). We are just now completing our upgrade from pgwatch2 to 4.1 and want to try and reduce the number of partitions created until we get chance to start consuming v5.x.

Thank you for your time!

[pashagolub]

Hello. Yeah, sure. You may use the function from that commit and pgwatch should use it.

[seanzechman]

Great! Thanks for the reply, have a great day!