🎩 "🎶 Oh, the joys of DBA life: where we set work_mem to 2MB and then wonder why our servers die a fiery, OOM-induced death after munching on 2TB of RAM. 🤦♂️ Surely, no one warned us that hardware can't save us from our own incompetence! 🙄"
https://mydbanotebook.org/posts/work_mem-its-a-trap/ #DBAlife #OOMerrors #serverstruggles #techhumor #databaseadmin #HackerNews #ngatedwork_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 set to 2 MB.
Something didn’t add up.
Hetty, like me, likes playing with monster hardware. 2 TB of RAM is not unusual in her world. But losing the whole cluster to a single query during peak operations is a very different kind of problem from a 3am outage.
Excited about the new open source utility pgedge-anonymizer for anonymizing sensitive information in your #PostgreSQL database? If you have any questions or just want to let us know what you think, join the discussion on HackerNews!
https://news.ycombinator.com/item?id=46290635
#dataprotection #cybersecurity #compliance #data #databaseadmin #securityengineer #datasecurity
Show HN: PgEdge Anonymizer – for replacing PII in test databases from prod | Hacker News
DB2 Database Upgrade Error: Resolving SYS_GET_TEMP_STORAGE Issue
DB2 Database Upgrade: Troubleshooting SYS_GET_TEMP_STORAGE errors during upgrades. Learn practical solutions & preventative measures for smoother upgrades.
#DB2Upgrade #DatabaseError #SYS_GET_TEMP_STORAGE #DB2Tips #SQLSolutions #DatabaseAdminhttps://tech-champion.com/database/db2luw/db2-database-upgrade-error-resolving-sys_get_temp_storage-issue/...
SQL Table Data Retrieval: Handling Tables With and Without Primary Keys
Learn efficient SQL Table Data Retrieval techniques for SQL Server, handling tables with & without primary keys. Master comprehensive column metadata retrieval for robust data analysis!
#SQLServer #DatabaseAdmin #DataAnalysis #SQLquery #DataRetrieval #ColumnMetadatahttps://tech-champion.com/database/sql-server/sql-table-data-retrieval-handling-tables-with-and-without-primary-keys/...
SQL Server Date Comparison: Ignoring Time in Date Columns
Master SQL Server Date Comparison techniques! Learn efficient methods to compare dates, ignoring time components for accurate results. Improve your data analysis skills now!
#SQLServerDateComparison #SQLServer #DateComparison #DatabaseAdmin #DataAnalysis #SQLhttps://tech-champion.com/database/sql-server/sql-server-date-comparison-ignoring-time-in-date-columns/...
SQL Date Conversion: Transforming Dates into Integers for Database Storage
Learn efficient SQL Date Conversion techniques for optimizing database storage & querying. Explore integer data type choices, batch processing, and robust error handling for reliable database systems.
#SQLDateConversion #DatabaseAdmin #SQLServer #DateOptimization #DataConversion #IntegerDataTypehttps://tech-champion.com/database/sql-server/sql-date-conversion-transforming-dates-into-integers-for-database-storage/...
Troubleshooting Db2 Database Issues: A Guide to Resolving Missing Databases
Db2 Database Issues: Troubleshooting guide for missing databases, misconfigured environment variables & connection problems. Learn how to diagnose & fix common DB2 LUW challenges.
#Db2DatabaseIssues #DatabaseTroubleshooting #DB2LUW #SQL #DatabaseAdmin #TechTipshttps://tech-champion.com/database/db2luw/troubleshooting-db2-database-issues-a-guide-to-resolving-missing-databases/...
DB2 Export Error Fix: Resolving Invalid Character Issues in File Paths
DB2 Export Error Fix: Solve common path issues by using forward slashes (/) in your DB2 EXPORT statements. This simple change prevents errors & improves data export reliability.
#DB2ExportErrorFix #DatabaseAdmin #DataExport #DB2Tips #ForwardSlash #DataManagementhttps://tech-champion.com/database/db2luw/db2-export-error-fix-resolving-invalid-character-issues-in-file-paths/...
DB2 Database Upgrade Error: Resolving SYS_GET_TEMP_STORAGE Issue
DB2 Database Upgrade: Troubleshooting SYS_GET_TEMP_STORAGE errors during upgrades. Learn practical solutions & preventative measures for smoother upgrades.
#DB2Upgrade #DatabaseError #SYS_GET_TEMP_STORAGE #DB2Tips #SQLSolutions #DatabaseAdminhttps://tech-champion.com/database/db2luw/db2-database-upgrade-error-resolving-sys_get_temp_storage-issue/...
SQL Table Data Retrieval: Handling Tables With and Without Primary Keys
Learn efficient SQL Table Data Retrieval techniques for SQL Server, handling tables with & without primary keys. Master comprehensive column metadata retrieval for robust data analysis!
#SQLServer #DatabaseAdmin #DataAnalysis #SQLquery #DataRetrieval #ColumnMetadatahttps://tech-champion.com/database/sql-server/sql-table-data-retrieval-handling-tables-with-and-without-primary-keys/...
N-gated Hacker News
pgEdge Postgres
zartom