...is like a relationship. It can be one the most glorious, bright and alive places to be but also the darkest, saddest and moodiest places... Unfortunately for the next 8 months this is what surrounds me.

If you have a large database, with some large tables and perform a mass update or delete statement, chances are that you will be out of a lot of disk space due to the MVCC architecture of the database engine. Updates are basically inserts and deletes, which bloats the database. If a database is say 100GB, and a table is 20GB, if you perform a mass update on all rows of that table, your database will grow in size to about 120GB. The old rows are left and will be re-used as time goes on, however therein lies the problem. Sometimes you do not have the luxury of lots of free disk space, and need to reclaim it immediately.

A first attempt at reclaiming the lost disk space is to perform a

vacuum full freeze verbose analyse <tablename>

I sometimes have a need to compare a specific file between the trunk of my SVN tree, and another branch of the same code using IntelliJ's built in difference viewer. But I always struggle to set it up correctly. Here is the rundown:

My tree is structured like:

Base -> Client -> Project -> trunk -> src
                          -> branches -> branch1 -> src
                                      -> branch2 -> src
                                      -> branch3 -> src

Googled for FileZilla Client, clicked on the Client Download link, got this:

There currently is no recent unstable version of FileZilla Client available. Please download the latest stable version

There is this product you just have to have, and only one obscure company sells it. After verifying the SSL certificate is good, you click "Purchase". Only to be greeted by this message:

I am now wondering whether they will ship it to [SHIP ADDRESS] and how they will deduct [TOTAL] from $LITTLE. Hmmm...