PostgreSQL: Index Tuning
Optimizing PostgreSQL is a relevant and controversial topic ("How much resources should I invest in optimization vs. hardware?"): The first part of the series, "Query Optimization Insights", made it to the top 4 posts on
2024-03-28 In an era where the costs for cloud services continue to soar, I want to outline how our data team has successfully managed to run the infrastructure of our energy trading company within the first year using only two PostgreSQL database instances - each equipped with just two CPU cores and four GB of RAM. Despite this minimal use of resources, internal business processes and analytics dashboards ... 2023-11-15 During the development of Python applications, I've continually asked myself how and when variables should be passed and initialized for the application's configuration. I want to be able to easily override the configuration for tests, for example, to use a local database for testing. But what exactly is application configuration, and why is it needed? The website
2023-10-02 After many years of working exclusively on-site in an office with colleagues who were also only familiar with this mode of work, the COVID-19 pandemic fundamentally changed how I work. Over a span of more than two years, I worked entirely from home. Now, I'm employed with a company that offers a hybrid work model, allowing both office work and remote work. Many of the principles and practices ... 2023-09-04PostgreSQL: Query Optimization Insights
Configuration of Python Applications
Remote work concepts in the office