News for hackers. Stuff that matters.
Re:PostgreSQL partitioning explained by RobotCaleb on Saturday May 03, 2014 @10:21PM (#7693093)
Can this be used to enforce a temporal limit on data? That is, if the check is for time to be within 24 hours of now will it purge older than 24 hours data as time progresses? My gut tells me no, but my gut is often wrong when it comes to databases.
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.
Re:PostgreSQL partitioning explained by batbomb on Saturday May 03, 2014 @10:55PM (#7693139)
you can in oracle, and I believe db2. It's called range partitioning.