Monthly Archives: January 2016

Let us consider the following case: I’ve got a huge project which you want to refactor. You checkout master, create a branch called cleanup and commit every change. Most of the refactoring is only style guide related so no change … Continue reading →

[part 1] Besides disabling autovacuum you can also try to increase the performance if you have got enough free resources. There are three important options for this: autovacuum_vacuum_cost_delay I lowered the sleep between two autovacuums to 0.2ms autovacuum_vacuum_cost_limit/vacuum_cost_limit (setting autovacuum_vacuum_cost_limit … Continue reading →

I am currently running a zabbix setup which is a bit bigger than the average ones, right now it receives ~2100 new values per second, generated by 169052 items. The data is stored in a postgresql database, and I am … Continue reading →

Sometimes you are developing on a huge new feature on a software project. If you are smart you do it in a separate (feature-) branch. During the development cycle you may modify existing code and after a few days you … Continue reading →