Am I the only one who is shocked to discover that payments (even very small sums) are stored for years on end, maybe indefinite??
Simple deleting a row that is 366 days old is not an option to keep the PostgreSQL DB relatively small?
Simple deleting a row that is 366 days old is not an option to keep the PostgreSQL DB relatively small?
To add on that, for some types of transaction the regulatory requirements are much, much longer - I was working in a jurisdiction where data of housing loan repayments had to be stored, by law, for 70 years after the end of the loan; so for a 30-year mortgage you'd have to be prepared to store every repayment for 100 years; and information on salaries calculated and paid has to be stored for 75 years (IMHO to resolve retirement-related disputes where it matters where you worked decades ago), passing on to national archive if the company is dissolved.