Robuta

https://mydbanotebook.org/tags/community/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/interviews/:/open.spotify.com/episode/0nKDbsckujngIa6ZyxSGaG?si=j_cbaJC1TDqIoBmVTm3cwQ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/simply-auditing-your-database-changes/ Simply auditing your database changes | My DBA Notebook database changesdba notebooksimplyauditing https://mydbanotebook.org/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/sketchnotes/patroni/ Patroni | My DBA Notebook Patroni is a high availability solution for PostgreSQL. Everu time I hear someone talking about patroni, they’re saying it’s pretty good. I wanted to knowmore... dba notebookpatroni https://mydbanotebook.org/tags/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/tags/performance/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/postgres-performance-regression-are-we-there-yet/ Postgres performance regression: are we there yet? | My DBA Notebook Every year, PostgreSQL gets faster. Researchers benchmarking the optimizer from version 8 through 16 found an average 15% performance improvement per major... postgres performancedba notebookregressionyet https://mydbanotebook.org/tags/memory/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/adding-your-patch-to-the-next-commitfest/ Adding your patch to the next commitfest | My DBA Notebook Imagine that moment: you’ve written your first patch for Postgres, the community said it’s a good idea and there’s no major problem with it. What’s the next... dba notebookaddingpatchnextcommitfest https://mydbanotebook.org/posts/work_mem-its-a-trap/ work_mem: it's a trap! | My DBA Notebook My friend Henrietta Dombrovskaya pinged me on Telegram. Her production cluster had just been killed by the OOM killer after eating 2 TB of RAM. work_mem was... dba notebookworkmemtrap https://mydbanotebook.org/tags/troubleshooting/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/cant-connect-to-postgres/ Can't connect to Postgres | My DBA Notebook This is kind of frustrating… You’ve been at it for the best part of the day and you can’t figure it out. You already tested that Postgres was running and that... dba notebookconnectpostgres https://mydbanotebook.org/posts/whats-wrong-with-postgres/ What's wrong with Postgres? | My DBA Notebook This post is part of several blog posts (at least two!) about Troubleshooting Postgres. Last time, we found out if Postgres was running and how to start it.... dba notebookwrongpostgres https://mydbanotebook.org/about/ About me | My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/dont-do-this-creating-useless-indexes/ Don't do this: creating useless indexes | My DBA Notebook For the first PGSQL Phriday of the year, my friend Hettie asked us to share a useful script we often use. I’d like to talk about a fight I’m having with some... dba notebookcreatinguselessindexes https://mydbanotebook.org/posts/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/interviews/ Interviews! | My DBA Notebook Please find bellow a collection of interviews I gave. dba notebookinterviews https://mydbanotebook.org/sketchnotes/ My DBA Notebook My personal blog about my PostgreSQL daily learnings dba notebook https://mydbanotebook.org/posts/is-postgres-running/ Is Postgres running ? | My DBA Notebook [2020-03-22 Edit: I got several tips from friends showing me better ways to test if Postgres was running that I decided to edit this post to make it better. I... dba notebookpostgresrunning