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
-
Followers161
-
Following158
-
Likes91
#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
Kade Klocko @KKlocko54401
16 Followers 2K Following
Sisesez @Sisesezf5N9
24 Followers 473 Following
Thorthew @Thorthewv1AG2S
30 Followers 481 Following
Aumwasum @Aumwasum787729
3 Followers 197 Following
PETER STANGEL @pstangelmd
2 Followers 43 Following
Ashok kumar @Ashokpole336
0 Followers 35 Following
Diparth Shah @diparthshah_
174 Followers 8K Following
Syed Ammad Hassan @SyedHassPro
1 Followers 69 Following life long learner , CS lover. I love nature .
Bynatree Data Solutio... @bynatree
5 Followers 140 Following We are a database specialist team predominantly Postgresql and mysql with extensive expertise installing, configuring, monitoring, fine-tuning, maintaining.
dachui @dachuizi888
31 Followers 781 Following
Alexander Schmitz Pet... @alexspeter_
280 Followers 2K Following Managed IT Services Consultant - IT enthusiastisch - DBA Oracle - certified Oracle Linux, LPCI-1 and Linux Foudation sysadmin
eason @eason0876076951
1 Followers 135 Following
babu kps @babukps
25 Followers 702 Following
MirandaSaul @hIoWzu5h193gume
84 Followers 7K Following
BreachDirectory @BreachDirectory
165 Followers 30 Following BreachDirectory is a data breach search engine & a data breach directory. Watch out for imposters — this is our only Twitter account.
Lukas Vileikis @lukasvileikis_
58 Followers 105 Following Database wrangler. Author. Security guy. Creator @BreachDirectory. All opinions are my own.
ChistaDATA Inc. @chistadata
246 Followers 924 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 106 Following Founder & CEO at 68Koncept Inc, MySQL Expert, Entrepreneur, Author of Glial (PHP framework) & PmaControl (MySQL Tools)
Vinicius Grippa @boringdba
48 Followers 136 Following A boring engineer talking about Linux, Databases, and other technology stuff.
DiAmi_art @DiAmi_art
0 Followers 7 Following
Chris Scott @ChrisSc73476967
17 Followers 383 Following
Andrew Moore @reddba_
8 Followers 124 Following Andy Moore, co-founder for RedDBA. MySQL and MariaDB coaching, training and consulting
Anna Widenius @AnjutaWren
144 Followers 311 Following
Masda @masda_X
342 Followers 3K Following irreversible dev. Crafting software since MMIV. For code, metal and fitness ⚡️🤘💪. Believer of the greater Creator, dad of 3.
superops @xidianwlc
70 Followers 2K Following 一个vibe coding的探索者，在调动各个AI厂商的AI接口构建最地道的markdown 编辑器，可以github搜索markrender就可以找到它
Anthony William @Tonny_William14
515 Followers 3K Following Inventor & Innovator || Designer || Avid Reader & Learner || A Supernatural Man with a Supernatural Origin and Supernatural Powers.
mirror @mirrorqcwh2024
98 Followers 954 Following
Jograd @keldcn
3 Followers 47 Following
zpf @zpf_sct
64 Followers 2K Following
Sidhant Goyal @Sid_1_0
789 Followers 455 Following Ex @peakxvpartners / @sequoia india, @mckinsey, @iitdelhi. Meditating with @heartfulness.
runelk @runelkio
142 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 275 Following
Karuppiah @karuppiah7890
657 Followers 4K Following Tinkerer. Learning Databases. Follow for content on life, tech, businesses, pricing, (and more? :))
soyisile @soyisile9412
42 Followers 161 Following
Md Arafat @dm_arafat10110
46 Followers 483 Following It's me Arafat, a professional digital marketer.
Murat Demirbas (Distr... @muratdemirbas
10K Followers 256 Following MongoDB Research: Distributed {Systems, Databases, Consensus} + Formal Methods ex-AWS, ex-Prof @SUNY Buffalo. https://t.co/IqZPhhtcCC Opinions my own
Jaime Crespo @jynus
770 Followers 662 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
430 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
17K Followers 238 Following Co-Founder Arta Finance. previously-(Google Pay, ChromeOS, Files, GStation... Payments & Next Billion Users teams @Google). Posting in my personal capacity.
Tushar | Persistence ... @Tushar307
6K Followers 4K Following #Bitcoin | Founder @PersistenceOne @pStakeFinance
Ashish Agrawal @dvbydt
8K Followers 257 Following Entrepreneur at heart, donning a VC jacket @peakxvpartners (formerly @sequoia India)
Appwrite @appwrite
128K Followers 35 Following Build like a team of hundreds_ Website: ➡️ https://t.co/OprOHjvube GitHub ➡️ https://t.co/VGT42Y8wVy Discord ➡️ https://t.co/FsRTsqqAyY
Himanshu Upreti @HimUpreti
548 Followers 395 Following Co-Founder at Ai Palette (acquired by GlobalData) | Tweets about books and startups | Forbes 30 Under 30
Parag Chordia @indianmusic
101K Followers 525 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
793 Followers 564 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
589 Followers 252 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
38K Followers 465 Following Co-Founder @ Blume | Blume Investment Team | (try DM’ing on https://t.co/zw0f9ueOwc)
Vani Kola (vanik.eth) @VaniKola
87K 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 353 Following Web dev (Rust/TS) and father. Building https://t.co/797K6EoE45 as my side project. Hoho.
Mayuresh Satao @MayureshSatao
360 Followers 564 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 @Accel_India
47K Followers 628 Following First partner to exceptional teams everywhere.
Kalaari Capital @Kalaari
46K Followers 502 Following A venture capital fund investing in early-stage,tech-oriented companies. Since 2006, Kalaari has empowered visionary entrepreneurs building for India’s tomorrow
Elevation Capital @ElevCap
45K Followers 480 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/oG5zBEyTC5
Peak XV Partners @peakxvpartners
97K Followers 667 Following Peak XV (formerly Sequoia Capital India & SEA) is a leading venture capital and growth investing firm investing across India, Southeast Asia and beyond.
Jim Tommaney @j_tommaney
138 Followers 525 Following Performance Engineering, Databricks. Previously CTO, Architect at InfiniDB (now MariaDB ColumnStore). Tweaking performance world-wide.
Ivan Zoratti @izoratti
275 Followers 8 Following Ivan is Product Manager for the Neo4j Graph Database
ᴍᴇʜᴍᴇᴛ @mehmetkose
773 Followers 1K Following A Pedestrian from 📍Pedestria, 0 → 1 Indie Developer React, NextJS, NodeJS, SEO #BuildInPublic Tweets are in English and Turkish mixed
Cagri Balkesen @cagri_balkesen
164 Followers 621 Following R&D in Cloud Databases, Datalake, Lakehouse, Modern Hardware & Big Data. Software Architect at Oracle. PhD alumni of ETH Zurich.
mortensi @mortensi
285 Followers 455 Following Coding and databases. Product Manager @redisinc. Views are solely mine.
Yalçın Yenigün @yalcinyenigun
900 Followers 575 Following Director of Engineering @deliveryherocom, Formerly @iyzico, @bilgeadam, @VodafoneTR, alumni of @Galatasaray_Uni
Nezih Yigitbasi @istanbul_techie
853 Followers 2K Following engineering leader passionate about distributed systems & open source, currently @Meta, previously @Netflix, @Intel, et al.
TheYonk @TheYonk3
59 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 Dev. A busy head with a calm mind. Maker: 👨🏻🔧 https://t.co/pdD0hN5ZsX 🔌 https://t.co/djUEUcMlMr ⚡️ https://t.co/8zPje6LeKp
Alex P @ifesdjeen
15K 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
249 Followers 742 Following Before, you are wise, after, you are wise. In between, you are otherwise. @[email protected]
Lorraine P @atomicmutton
642 Followers 1K Following learning is for life. look for justice. enjoy art. breathe. ex Timescale, Percona, Automatic.
Agora @AgoraIO
27K 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
109K Followers 184 Following #SocialMediaManagement software for businesses and agencies. Part of the @Zoho suite.
Shlomi Noach @ShlomiNoach
2K Followers 55 Following Engineer and database geek @planetscaledata. Open source author. Previously at @GitHub.
Jon Kartago Lamida @lamida
202 Followers 654 Following Software engineer, traveler, infosec student, books hoarder, perpetually blocked writer, lifelong learner, video games and Lego player.Trends for United States
You might like
