News for hackers. Stuff that matters.
Re:PostgreSQL partitioning explained by ddorian43 on Sunday May 04, 2014 @03:47AM (#7693661)
example you are keeping daily logs(daily partition), and you only want to keep the last 30 days, so you drop-table the latest partitions, which is faster than deleting X number of rows
Re:PostgreSQL partitioning explained by baddox on Sunday May 04, 2014 @06:21AM (#7693833)
In other words, it's different from a traditional index in that it physically stores like values together.