News for hackers. Stuff that matters.
Re:PostgreSQL partitioning explained by keithgabryelski on Saturday May 03, 2014 @10:42PM (#7693115)
if I understand you correctly, this type of thing is implemented by partitioning by hour in a day and then having a janitor process drop tables that are older than 24 hours.
Re:PostgreSQL partitioning explained by morgo on Sunday May 04, 2014 @12:23AM (#7693267)
ALTER TABLE .. TRUNCATE PARTITION should be much faster than deleting as well. At least it is in MySQL.