I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have (relatively) large dbs (compared to prod). Enter the pgstattuple extension to help me determine how much free space is in my tables. Step 1: Installing…
Month: November 2024
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all who posted on this topic! Here are the highlights of the posts (in alphabetical order by last name): Chad Callihan – In his post, Chad talks about stepping away: “Sometimes, the best way…
How can you achieve good enough without compromising the process/product? In the world of database technology, striving for perfection is a double-edged sword. While high standards are important for maintaining reliable, efficient systems, trying for absolute perfection can quickly lead to back-breaking workloads and burnout.…