MinervaSQL @MinervaSQL
Consulting, Enterprise-Class 24*7 Support and Remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse #mysql #mariadb #clickhouse #PostgreSQL minervasql.com San Francisco, CA Joined April 2015-
Tweets581
-
Followers159
-
Following154
-
Likes90
#PostgreSQL allocates memory for connections,query execution,and caching.Parameters like shared_buffers,work_mem, and maintenance_work_mem control usage.Proper tuning ensures performance and avoids OOM issues.#PostgreSQLPerformance @MinervaDB #opensource zurl.co/wnsgR
#PostgreSQL allocates memory for connections,query execution,and caching. Parameters like shared_buffers,work_mem, and maintenance_work_mem control usage.Proper tuning ensures performance and avoids OOM issues.#PostgreSQLPerformance @minervaDB #opensource zurl.co/wnsgR
In #PostgreSQL, hard parsing occurs on 1st query run or after schema/stats changes. It analyses and optimizes queries, which is resource-heavy for complex ones. Query plan caching minimizes this overhead..#PostgreSQLPerformance @minervaDB #opensource #dbahttps://zurl.co/4APHN
#PostgreSQL 15,released Oct 3,2021, adds parallel VACUUM/ANALYZE,better partition pruning, JIT, improved indexing, JSON path queries, and full-text search, boosting performance, scalability, and security.#PostgreSQLPerformance @minervaDB #opensource #dba zurl.co/tdkd2
#MariaDB10.8 introduces IN, OUT, and INOUT parameters for functions, lag-free ALTER TABLE replication, descending indexes,InnoDB updates like auto-sized buffer pools,JSON histograms,GTID binary logs & new system variables. @minervaDB #opensource #dba zurl.co/I0MUP
Pagination in #ClickHouse is crucial for hand large dataset efficiently,especially in interactive application, provides multiple pagination methods, emphasis performance & scalability for seamless user experience@ChistaDATA #opensource#olap#dataanalytics zurl.co/DXu2l
#LSM storage systems excel in write-heavy workloads by using in-memory tables (memtables) and merging sorted data on disk. This enables fast writes and efficient reads, ideal for#NoSQL databases like#Cassandra or#RocksDB. @minervaDB #opensource #dba zurl.co/bfKwB
External joins in #GoogleBigQuery are optimized with partitioning, clustering, reduced data scans, efficient joins, and better data formats to cut costs and boost performance. @minervaDB #opensource #dba #PostgreSQLPerformance zurl.co/eoPKF
Adjacency Model in #PostgreSQL stores hierarchical data by referencing parent rows. It's easy to implement and suits structures like org charts but requires indexing and optimization for efficient querying.@minervaDB #opensource#dba #PostgreSQLPerformancehttps://zurl.co/uRTAv
Wait events are not explicitly documented in ClickHouse, understanding potential bottlenecks and their causes in ClickHouse can help diagnose and address performance issues. #sql #sqltips #dba @ChistaDATA #opensource #olap zurl.co/QmFz6
Over-fetching in #ClickHouse, as in other database systems, occurs when a query retrieves more data than necessary. This can lead to increased resource consumption and slower query performance. #postgres #sql #dba @ChistaDATA #opensource #olap zurl.co/j3EJC
Wave Analytics (Einstein Analytics) integrates with external databases like #postgresQL to provide advanced data visualisation and insights. #postgres #sql #dba @minervaDB #opensource zurl.co/L5rVu
A Kimball Helper Table in #postgresQL in modern banking improves performance analysis by pre-aggregating data for optimized queries, aiding efficient reporting and informed decision-making. #postgres #mysql #sql @minervaDB #opensource zurl.co/HszJj
A parse call analyses a SQL statement for syntax and creates an execution plan. Using prepared statements allows #MySQL to reuse the parse tree and execution plan, improving efficiency for repeated queries. #MySQLPerformance @minervaDB #opensource #dba zurl.co/8abQf
#PostgreSQL allocates memory for connections,query execution,and caching. Parameters like shared_buffers,work_mem, and maintenance_work_mem control usage.Proper tuning ensures performance and avoids OOM issues.#PostgreSQLPerformance @minervaDB #opensource zurl.co/wnsgR
In #PostgreSQL, hard parsing occurs on 1st query run or after schema/stats changes. It analyses and optimizes queries, which is resource-heavy for complex ones. Query plan caching minimizes this overhead..#PostgreSQLPerformance @minervaDB #opensource #dbahttps://zurl.co/4APHN
#PostgreSQL 15,released Oct 3,2021, adds parallel VACUUM/ANALYZE,better partition pruning, JIT, improved indexing, JSON path queries, and full-text search, boosting performance, scalability, and security.#PostgreSQLPerformance @minervaDB #opensource #dba zurl.co/tdkd2
#MariaDB10.8 introduces IN, OUT, and INOUT parameters for functions, lag-free ALTER TABLE replication, descending indexes,InnoDB updates like auto-sized buffer pools,JSON histograms,GTID binary logs & new system variables. @minervaDB #opensource #dba zurl.co/I0MUP
Pagination in #ClickHouse is crucial for hand large dataset efficiently,especially in interactive application, provides multiple pagination methods, emphasis performance & scalability for seamless user experience@ChistaDATA #opensource#olap#dataanalytics zurl.co/DXu2l
#LSM storage systems excel in write-heavy workloads by using in-memory tables (memtables) and merging sorted data on disk. This enables fast writes and efficient reads, ideal for#NoSQL databases like#Cassandra or#RocksDB. @minervaDB #opensource #dba zurl.co/bfKwB
Candido Sales @candidosales
1K Followers 6K Following from ☀️ Piauí, 🇧🇷 in 🇨🇦 - Software Engineer ... ✨ Trying every day ...
Frances @Xusi95199
187 Followers 7K Following I’m learning to love the sound of my feet walking away from things not meant for me.
Sisesez @Sisesezf5N9
20 Followers 450 Following
Thorthew @Thorthewv1AG2S
18 Followers 463 Following
Aumwasum @Aumwasum787729
3 Followers 181 Following
PETER STANGEL @pstangelmd
4 Followers 134 Following
Ashok kumar @Ashokpole336
0 Followers 35 Following
Diparth Shah @diparthshah_
75 Followers 7K Following
Syed Ammad Hassan @SyedHassPro
1 Followers 66 Following life long learner , CS lover. I love nature .
Bynatree Data Solutio... @bynatree
7 Followers 153 Following We are a database specialist team predominantly Postgresql and mysql with extensive expertise installing, configuring, monitoring, fine-tuning, maintaining.
dachui @dachuizi888
5 Followers 739 Following
Alexander Schmitz Pet... @alexspeter_
276 Followers 2K Following Managed IT Services Consultant - IT enthusiastisch - DBA Oracle - certified Oracle Linux, LPCI-1 and Linux Foudation sysadmin
eason @eason0876076951
2 Followers 219 Following
babu kps @babukps
18 Followers 747 Following
Logoutify (BreachDire... @BreachDirectory
172 Followers 30 Following BreachDirectory was a data breach directory & search engine. The service is now available via @logoutify.
Lukas Vileikis @lukasvileikis_
55 Followers 104 Following Database wrangler. Author. Security guy. Creator @BreachDirectory. All opinions are my own.
ChistaDATA Inc. @chistadata
184 Followers 918 Following Building #OpenSource Real-Time Analytics on #ClickHouse #ChistaDATADBaaS #ClickHouseSupport #DataAnalytics #ColumnStore #BigData #ML #AI #Analytics #Data #Tech
Aurélien LEQUOY @Aurelien_LEQUOY
89 Followers 104 Following Founder & CEO at 68Koncept Inc, MySQL Expert, Entrepreneur, Author of Glial (PHP framework) & PmaControl (MySQL Tools)
Vinicius Grippa @vgirppa
46 Followers 135 Following A boring engineer talking about Linux, Databases, and other technology stuff.
DiAmi_art @DiAmi_art
0 Followers 7 Following
René Cannaò @rene_cannao
3K Followers 5K Following @ProxySQL author | Database systems & production realities | AI tools, workflows & leverage for tech builders | Solopreneur systems in infra
Chris Scott @ChrisSc73476967
5 Followers 384 Following
Andrew Moore @reddba_
10 Followers 129 Following Andy Moore, co-founder for RedDBA. MySQL and MariaDB coaching, training and consulting
Anna Widenius @AnjutaWren
147 Followers 309 Following
Masda @masda_X
115 Followers 3K Following irreversible dev. Crafting software since MMIV. For code, metal and fitness ⚡️🤘💪. Believer of the greater Creator, dad of 3.
superops @xidianwlc
61 Followers 3K Following 一个vibe coding的探索者，在调动各个AI厂商的AI接口构建最地道的markdown 编辑器，可以github搜索markrender就可以找到它
Anthony William @Tonny_William14
421 Followers 3K Following Inventor & Innovator || Designer || Avid Reader & Learner || A Supernatural Man with a Supernatural Origin and Supernatural Powers.
mirror @mirrorqcwh2024
80 Followers 1K Following
Jograd @keldcn
2 Followers 46 Following
zpf @zpf_sct
21 Followers 2K Following
Sidhant Goyal @Sid_1_0
843 Followers 478 Following principal @crane_vc for India ex @peakxvpartners / @sequoia india, @mckinsey, @iitdelhi. meditating with @heartfulness.
runelk @runelkio
65 Followers 3K Following Fullstack dev, #deno, #golang, #graphql, #prisma, #ai, #protobuf, #buildless, #serverless, harmless weirdness, no impressive dress, no goals - only process
gozila @goknifefly
6 Followers 274 Following
Karuppiah @karuppiah7890
551 Followers 4K Following Tinkerer. Learning Databases. Follow for content on life, tech, businesses, pricing, (and more? :))
soyisile @soyisile9412
36 Followers 157 Following
Md Arafat @dm_arafat10110
40 Followers 477 Following It's me Arafat, a professional digital marketer.
Murat Demirbas (Distr... @muratdemirbas
11K Followers 257 Following MongoDB Research: Distributed Systems, Databases, Formal Methods ex-AWS, ex-Prof SUNY Buffalo. Blog at: https://t.co/IqZPhhtcCC Opinions my own
Jaime Crespo @jynus
759 Followers 651 Following 👋 Bonjour, hola, & hello! 👨💻 Senior SRE/DBA by day, 🎮 gamedev & 🤖 Godot enthusiast by night. 💻 MySQL, Linux & Python, always looking to learn +. He/him.
skeema.io @skeema_io
64 Followers 35 Following Declarative, pure-SQL schema management solution for MySQL and MariaDB
Felipe Schneider ⚪ @Felipes88
425 Followers 1K Following MS SQL DBA | Azure DBA | MS Certified - DP-900, DP-300, AZ-900| https://t.co/0rvV0MqzrZ… Begining my path as Data Engineer and Data Analysis
Caesar Sengupta @caesars
16K Followers 237 Following Co-Founder Arta Finance. previously-(Google Pay, ChromeOS, Files, GStation... Payments & Next Billion Users teams @Google). Posting in my personal capacity.
Ashish Agrawal @dvbydt
10K Followers 265 Following Entrepreneur at heart, donning a VC jacket @peakxvpartners (formerly @sequoia India)
Appwrite @appwrite
127K Followers 46 Following Build like a team of hundreds_ Website: ➡️ https://t.co/OprOHjw20M GitHub ➡️ https://t.co/VGT42Y94L6 Discord ➡️ https://t.co/FsRTsqr8ow
Himanshu Upreti @HimUpreti
835 Followers 414 Following Co-Founder at Ai Palette (acquired by GlobalData) | Tweets about books and startups | Forbes 30 Under 30
Parag Chordia @indianmusic
99K Followers 535 Following Founder and CTO Telepathic, Formerly Chief Scientist Smule, Founded Georgia Tech Music Intelligence Lab, CCRMA / Stanford Alum https://t.co/hezrvPKWVm
Ayush bansal @ayushbansal08
766 Followers 561 Following Career Counselor Entrepreneur @idreamcareer | Helping 20 mn+ students in career & college discovery | @Bwbusinessworld 40u40 | Father of a 👶 & 🐶 | Minimalist
Life at Couchbase @couchbaselife
240 Followers 78 Following At Couchbase, it's in our nature to embolden and explore. We work hard to make sure that our perks and benefits reinforce employees come first!
Ali LeClerc @ali_leclerc
574 Followers 259 Following Building OS communities. Retired sprinter. Crossword enthusiast. Go bulldogs.
Amit Somani ♫ @amitsomani
25K Followers 2K Following Professionally: High Conviction, High Support VC investor (Prime Ventures); Personally: Live fully & evolve every day; Serve the world through what I learn.
Karthik Reddy @BKartRed
39K Followers 471 Following Co-Founder @ Blume | Blume Investment Team | (try DM’ing on https://t.co/zw0f9ueOwc)
Vani Kola @VaniKola
85K Followers 94 Following Managing Director @Kalaari. Committed to entrepreneurship in India, meditation, Yoga enthusiast, avid hiker and mom of two girls.
Avnish Bajaj @avnish
42K Followers 1K Following Entrepreneur & Investor (Z47 @z47_vc, Baazee = @eBay India). Family man. Global citizen. Traveler. Adventurer. Seeker.
Serhii Potapov @greyblake
7K Followers 355 Following Web dev (Rust/TS) and father. Building https://t.co/797K6EoE45 as my side project. Hoho.
Mayuresh Satao @MayureshSatao
351 Followers 556 Following Founder and CEO @geniobits | Developer| Django | Django Rest Framework | Android | Python Automation | Security Researcher |
Rupeek @rupeekapp
1K Followers 13 Following India's leading asset-backed fintech platform | 5 Lakh+ happy customers in 25+ cities
Accel in India @AccelIndia
48K Followers 308 Following First partner to exceptional teams everywhere.
Kalaari Capital @Kalaari
46K Followers 499 Following Empowering visionary entrepreneurs building for India’s tomorrow. 🚀 Regulatory Registration: https://t.co/NpSgW1vaUK
Elevation Capital @ElevCap
49K Followers 479 Following Early stage VC firm. Proud partners of visionary founders. Never too early to get in touch with us. Built for the Audacious. https://t.co/oG5zBEylMx
Peak XV Partners @peakxvpartners
102K Followers 687 Following Peak XV Partners (formerly Sequoia Capital India & SEA) is a global VC firm with 20+ years of experience partnering with founders to build enduring companies.
Jim Tommaney @j_tommaney
138 Followers 519 Following Performance Engineering, Databricks. Previously CTO, Architect at InfiniDB (now MariaDB ColumnStore). Tweaking performance world-wide.
ᴍᴇʜᴍᴇᴛ @mehmetkose
779 Followers 1K Following React, NextJS, Astro, NodeJS, Typescript, Technical SEO shipped: https://t.co/42VDBEPbe8 coming soon: https://t.co/4AWl1sgPBu
Cagri Balkesen @cagri_balkesen
162 Followers 614 Following R&D in Cloud Databases, Datalake, Lakehouse, Modern Hardware & Big Data. Software Architect at Oracle. PhD alumni of ETH Zurich.
Yalçın Yenigün @yalcinyenigun
872 Followers 580 Following Director of Engineering @deliveryherocom, Formerly @iyzico, @bilgeadam, @VodafoneTR, alumni of @Galatasaray_Uni
Nezih Yigitbasi @istanbul_techie
835 Followers 3K Following engineering leader passionate about AI, distributed systems, and open source; currently @MSL/Meta Superintelligence Labs, previously @Netflix, @Intel, et al.
TheYonk @TheYonk3
58 Followers 40 Following The Yonk is the CXO for Percona. He has been kicking around databases and open source for more then 20 years.
Mustafa Uysal @m_uysl
2K Followers 998 Following Software maker, still fixing things on the internet. Slightly geeky. 👨🏻🔧 https://t.co/pdD0hN6xiv 🔌 https://t.co/djUEUcMTBZ ⚡️ https://t.co/8zPje6LMzX
Alex P @ifesdjeen
16K Followers 1K Following Distributed and Storage Systems. Apache Cassandra Committer and PMC member. Author of Database Internals @therealdatabass. Discord: https://t.co/8LwhZom9eQ
Ian Gilfillan @pipeweed
243 Followers 736 Following Before, you are wise, after, you are wise. In between, you are otherwise. @[email protected]
Agora @AgoraIO
26K Followers 1K Following Behind every great app is a great API. We power the real-time APIs for live voice, video, and chat in the world's biggest apps. (NASDAQ: $API)
Zoho Social @ZohoSocial
118K Followers 181 Following #SocialMediaManagement software for businesses and agencies. Part of the @Zoho suite.
Shlomi Noach @ShlomiNoach
2K Followers 56 Following Engineer and database geek @planetscaledata. Open source author. Previously at @GitHub.
Jon Kartago Lamida @lamida
193 Followers 664 Following Software engineer, traveler, infosec student, books hoarder, perpetually blocked writer, lifelong learner, video games and Lego player.
Ajey Gore @AjeyGore
24K Followers 628 Following I know nothing about AI. Building better experiences for people. tinkering along the line on AI and Infra Orchestration @getclawstation
Niranjan Paranjape @niranjan_p
4K Followers 542 Following Hacker. Formerly: CTO @jivaag CTO @GojekIndonesia, Founder and CTO, @C42Engineering. Organizer: @RubyConfIndia.
Jeremy Tinley @techwolf359
1K Followers 812 Following Principal Systems Architect for Etsy. Co-author of "High Performance MySQL, 4th edition" Drinker of wine. Consumer of chocolate. Maker of Dad Jokes.You might like
