Month: November 2013
effective_cache_size: Better set it right
PostgreSQL knows a parameter called effective_cache_size. To many this is one of the most mysterious settings in the entire PostgreSQL config. Maybe this is the core reason why many people just completely ignore this setting – in many cases this is not the best idea of all. effective_cache_size can have a serious impact on execution […]
Read more
Operator classes explained
After my morning session in Dublin some people asked me to share the codes of an operator class I created for demo reasons. This posting is supposed to cover those codes. What is an operator class? In PostgreSQL an index is not a hardwired thing, capable of following just one strategy. Instead an index is […]
Read more