Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don't actually have ‘REINDEX CONCURRENTLY' command – it's a bit tricky.
So, since I will be doing this on several databases, decided to write a script that will handle the work for me.
Continue reading Concurrent REINDEX of all indexes in database
For those of you that don't know – Tmux is program similar to screen, but written from scratch, with different functionality, approach, and capabilities.
I would like to show one particular case where I found that Tmux does something that screen doesn't.
Continue reading Why I like tmux?