When you do partition your tables monthly, then comes the question of when to create next partitions. I tend to create them just the week before next month and I have some nice nagios scripts to alert me in case I’ve forgotten to do so. How to check that by hand in the end of a month?
We’re using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his own schema, and all is replicated nicely on the central host, thanks to Londiste, as you might have guessed already.
As it happens, I’ve got some environments where I want to make sure HOT (
aka Heap Only Tuples) is in use. Because we’re doing so much updates a
second that I want to get sure it’s not killing my database server. I not
only wrote some checking view to see about it, but also made
quick article about
it in the French PostgreSQL website. Handling
#postgresql means that I’m now bound to write about it in