June 2010
2 posts
Postgres routine (and not so routine) maintenance
Postgres is our DB of choice. We run all our vTrack and vWork systems on it.
We have lately been developing data archiving and culling strategies to manage data growth and disk consumption.
I’ve found a few hints that are best shared.
Culling Old Data to Recover Disk Space
The initial thought is to perform a quick delete of the old data, a-la:
DELETE FROM table1 where date < [some...
3 tags
Useful Rules and Guidelines
In our complex lives, rules and guidelines help us avoid rethinking everything that crosses our paths. Rules are the outcomes of pattern recognition.
We recognise repeating or similar stimulus in the world, and our ‘understanding’ of these stimuli is a “rule”.
I’m not quoting anyone here, and I may be oversimplifying the case, but I think this is a reasonable...