I'm using a RDS instance(v 11.9) which runs postgres db and i need to delete old records from a table. As per my study, it seems like we can create an event trigger to delete the old records when an insertion occurs. But the trigger will be made for each and every frequent insertions which cause unnecessary traffic. So are there any effective solution for this (ie any inbuilt automatic deletion methods or scheduled jobs)?
FYI, the table contains a timestamp column