As part of a new and fairly large project I have a need to partition a few postgres tables and have a rolling daily window. That is.. I want to organize data by a timestamp storing each day in its own partition and maintain 90 days of historical data. Doing this is possible in Postgresql [...]
Browsing Posts tagged oracle
What I do – Dynamic Daily Table Partitions With Postgres
January 19, 2012
No comments
What I do – Practical Data Visualization
March 28, 2011
No comments
I’m often ask what it is I do for a living… and being lazy I usually just say ‘computer stuff’. In an effort to provide a little more context to anyone who may be interested this is one in a series of postings where I’ll cover some aspect of what it is I do. In [...]
