Techiio-author
Started by Bruce MccullamSep 24, 2021

Open
Managing ever growing history tables

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

In my company,we are keeping history tables for update delete etc. in real tables. However, we do not want to too big table. They are growing indefinitely. We should implement a strategy that removes the old records from the history tables. We still don't want to lose this data however. For product table, one solution is take all the history records for a product and store it as jsonb. However, We do not know how we can keep dates as date-time columns also we do not know is it best strategy. I am wondering What is the best solution for this problem and keeping jsonb in date-time columns is possible.

0 Replies

You must be Logged in to reply
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance