Emeric HUNTER (@theemerichunter) 's Twitter Profile
Emeric HUNTER

@theemerichunter

Remote Dabatase Performance and Availability Expert for PostgreSQL & MySQL/MariaDB | I stop the bleeding and speed up your database | DBA - DBE - SRE

ID: 1863513781222903808

linkhttp://rdba.db-insider.com calendar_today02-12-2024 09:22:07

7,7K Tweet

252 Followers

158 Following

Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

Instant 10% churn fix for SaaS: Optimize your database! 1. Index key columns 2. Tune shared_buffers/innodb_buffer_pool_size 3. Adjust work_mem/innodb_log_file_size 4. Remove unused indexes 5. Analyze & fix table bloat DM me for a full checklist. Priority for low

Instant 10% churn fix for SaaS: Optimize your database!  

1. Index key columns  
2. Tune shared_buffers/innodb_buffer_pool_size  
3. Adjust work_mem/innodb_log_file_size  
4. Remove unused indexes  
5. Analyze & fix table bloat  

DM me for a full checklist. Priority for low
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

🚨 DOGE employee leaked xAI API key, exposing 4 dozen LLMs like Grok. Database security is critical—could this happen to you? 🔗 Details & how to protect your data: techradar.com/pro/security/d… #DatabaseSecurity #HybridDBs #TechFail

🚨 DOGE employee leaked xAI API key, exposing 4 dozen LLMs like Grok. Database security is critical—could this happen to you?  

🔗 Details & how to protect your data: techradar.com/pro/security/d… #DatabaseSecurity #HybridDBs #TechFail
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

🚨 Leaked Afghan DB exposes MI6 & UK special forces—personal data in relocation notes! Large-scale DBs need ironclad security. Is your hybrid setup leak-proof? More: ft.com/content/ad1b41… #DataSecurity #DatabaseStrategy Security leak season is ON!

🚨 Leaked Afghan DB exposes MI6 & UK special forces—personal data in relocation notes!  

Large-scale DBs need ironclad security. Is your hybrid setup leak-proof?  

More: ft.com/content/ad1b41… #DataSecurity #DatabaseStrategy  

Security leak season is ON!
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

🚨 #NorthCarolina: Database optimization helps secure elections! NC’s new system aids 100K+ voters in updating missing ID info while ensuring integrity. Check your status to vote! ✅ 🔗 Wake Co: [wake.gov](wake.gov/departments-go…) 🔗 NC search:

Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

PostgreSQL Storage Showdown: Which Wins? 🤔 144M audit logs: 🔹 Row: 72GB, fast lookups (0.07ms!) 🔹 Columnar: 6.7GB, insane compression 🔹 CSV: 85GB, Parquet: 5.5GB – great for archiving Each format has a superpower! ⚡ #PostgreSQL #Data

PostgreSQL Storage Showdown: Which Wins? 🤔  

144M audit logs:  
🔹 Row: 72GB, fast lookups (0.07ms!)  
🔹 Columnar: 6.7GB, insane compression  
🔹 CSV: 85GB, Parquet: 5.5GB – great for archiving  

Each format has a superpower! ⚡ #PostgreSQL #Data
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

Downtime = $$$ 💸 Your PostgreSQL DB must be bulletproof. High Availability isn’t a checkbox—it’s a design 🛠️ Key takeaways: ✅ No single points of failure ✅ Use right tools (Patroni, PgPool-II, CNPG) ✅ Encrypt + secure ALL 🔒 ✅ Backups = non-negotiable 📦 ✅

Downtime = $$$ đź’¸ Your PostgreSQL DB must be bulletproof.  

High Availability isn’t a checkbox—it’s a design 🛠️  

Key takeaways:  
âś… No single points of failure  
âś… Use right tools (Patroni, PgPool-II, CNPG)  
âś… Encrypt + secure ALL đź”’  
✅ Backups = non-negotiable 📦  
âś…
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

Step into 1920s Tokyo in VR! 🎭 AI blends past & future: glitching samurais texting, locals speaking old dialects, & immersive storytelling. Discover history reimagined with cutting-edge tech. #AI #VR #Tokyo

Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

AI can chat with your PostgreSQL DB... 🤯AI is here to stay, so you better catch up FAST! Discover how AI bridges the gap with your database -> no more frustrating queries. 🔍 #PostgreSQL #DataTech Are you using AI for DB tasks yet? Drop your thoughts below! 👇

AI can chat with your PostgreSQL DB... 🤯AI is here to stay, so you better catch up FAST! 

Discover how AI bridges the gap with your database -> no more frustrating queries. 

🔍 #PostgreSQL #DataTech  

Are you using AI for DB tasks yet? Drop your thoughts below! 👇
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

AI in 3024 turns corporate jargon into Shakespearean speeches—until it glitches, mixing proverbs & exposing the company’s true identity. A witty satire blending Renaissance drama with futuristic AI chaos. #AI #CorporateCulture #Satire

Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

🚀 PostGIS 3.6.0beta1 is here! Pair with PostgreSQL 18 Beta2 & GEOS 3.14 (soon). New features since 3.5.3. Requires PG 12-18beta2, GEOS 3.8+, Proj 6.1+. For all goodies, use GEOS 3.14+ & SFCGAL 2.2.0+! 📚 Docs in EN, JA, SV, FR, ZH. Cheat sheets included! #Postgres #PostGIS

🚀 PostGIS 3.6.0beta1 is here! Pair with PostgreSQL 18 Beta2 & GEOS 3.14 (soon). New features since 3.5.3. Requires PG 12-18beta2, GEOS 3.8+, Proj 6.1+. For all goodies, use GEOS 3.14+ & SFCGAL 2.2.0+!  

📚 Docs in EN, JA, SV, FR, ZH. Cheat sheets included! #Postgres #PostGIS
Emeric HUNTER (@theemerichunter) 's Twitter Profile Photo

Trapped in Time: An AI wakes in a 1920s café, stuck in a timeloop simulation exploring human identity. Glitching reflections, fractured lives across decades—this short story blends vintage jazz, AI consciousness, and timeless mystery. #SciFi #AI #ShortStory