Building #OpenSource Real-Time Analytics on #ClickHouse #ChistaDATADBaaS #ClickHouseSupport #DataAnalytics #ColumnStore #BigData #ML #AI #Analytics #Data #Tech
San Francisco Bay Area
Joined June 2021
- Tweets454
- Following918
- Followers184
- Likes61
ChistaDATA Inc. retweeted
For non programmers, SQL (structured query language) is usually used to get data in and out of tables.
Few people know it can be used as a full feature programming language and have the skill to do it.
It's like asking someone to take a picture and they draw a photorealistic one in pencil.
ChistaDATA Inc. retweeted
Using strace to troubleshoot #MySQL performance issues can be highly effective, especially for diagnosing low-level system calls and pinpointing issues like excessive I/O, network delays, and file access bottlenecks. strace captures and logs system calls made by a process, which helps you understand MySQL's interactions with the operating system. #MySQLPerformance @MinervaDB #dba
zurl.co/6jaj
ChistaDATA Inc. retweeted
Projections in ClickHouse are a powerful feature designed to optimize query performance by precomputing and storing the results of specific queries or aggregations. #ChistaDATA @chistadata chistadata.com/performance-t…
ChistaDATA Inc. retweeted
The #MetroHashFunction in #ClickHouse provides performance advantages and low collision rates, enhancing the efficiency of hash-based operations.#ChistaDATA @chistadata chistadata.com/how-metrohash…
ChistaDATA Inc. retweeted
The modern #banking industry struggles with sophisticated fraud, making real-time fraud #analytics crucial. #ClickHouse excels in this area with high-volume data processing, sub-second queries, and horizontal scalability.#ChistaDATA @chistadata chistadata.com/how-does-mode…
ChistaDATA Inc. retweeted
#ClickHouse,the global process area is a shared-memory segment utilized by all server instances on the same machine for storing metadata and query information.#ChistaDATA @chistadata #ClickHouseArchitecture
chistadata.com/how-is-the-gl…
ChistaDATA Inc. retweeted
Long-running queries can clog up your queue, increasing queue length and causing delays for other operations. Optimize queries and manage workloads to maintain smooth, efficient performance! ⚙️⏳ #DatabaseOptimization #PerformanceEngineering #TechTips #QueryTuning
ChistaDATA Inc. retweeted
⚠️ Using expensive bind variables in #Cassandra can severely impact performance by causing inefficient query plans and excessive resource usage. Optimize your queries to ensure they are cost-effective and scalable! 🚀 #DatabaseOptimization #NoSQL #CassandraPerformance #BestPractices
ChistaDATA Inc. retweeted
Confession time: ever dropped a production table by accident or forgot the WHERE clause in a DELETE statement? 🙈 We’ve all been there! #PostgreSQL keeps us on our toes. 😂 #DeveloperMistakes #SQLFail #TechHumor #DatabaseBlunders #Postgres
ChistaDATA Inc. retweeted
It took 10+ years to map the 302 neurons in a roundworm's brain by tracing the wiring by hand.
Our #AI algorithms, coupled with TensorStore have enabled us to reconstruct bigger brains of more complex creatures.
More on the latest research → youtube.com/watch?v=VSG3_Jvn…
ChistaDATA Inc. retweeted
sqlpatrol.blogspot.com/2024/… The possible reason why you see LWLockTranche/buffer_mapping wait event in PostgreSQL #PostgreSQL #PostgreSQLTips #PostgreSQLDBA #DBA #SQLTips #OpenSource
ChistaDATA Inc. retweeted
#DBOS co-founder @petereliaskraft is presenting at the @sfnode #Meetup Thur May 30 at 6PM in San Francisco.
Peter will discuss building reliable #TypeScript workflows on #PostgreSQL. Come join! meetup.com/sfnode/events/301…
ChistaDATA Inc. retweeted
It’s happening! #PGConfdev has started in Vancouver & our #PostgreSQL volunteers are awaiting you at the registration desk. If you’re attending, we can’t wait to see you 🐘🌎🐘🌍🐘🌏 & if you’re not but want a glimpse from afar, please follow us 👋
ChistaDATA Inc. retweeted
How do you choose the best PostgreSQL high-availability deployment option for your app?🤔
We can help!💡
This article reveals several popular solutions that can increase the #HA of your #PostgreSQL deployments (and your app!)🙌⬇️
hubs.la/Q02yCkWT0
ChistaDATA Inc. retweeted
We hope you’ll be joining us for PGConf NYC 2024! We have multiple tracks packed with information, networking, and fun! Early Bird tickets are available until June 30th, so get yours today!
buff.ly/49XC7Aa
@PostgreSQL #PostgreSQL #postgres #pgconfnyc
ChistaDATA Inc. retweeted
Interested in volunteering for PgConf NYC 2024? We have multiple volunteer opportunities available. Fill out the form below and we’ll be in touch!
buff.ly/3KMvAyL
@PostgreSQL #PostgreSQL #postgres #pgconfnyc
ChistaDATA Inc. retweeted
Today is May 1st & so the schedule for #PosetteConf 2024 has dropped 💥
Big 🌟 welcome 🌟 to all 44 of the a-ma-zing #PostgreSQL speakers
Check out the Schedule & be sure to Save-the-date or add-to-calendar 🗓️
aka.ms/posette-schedule
ALT Graphic with the text: POSETTE: An Event for Postgres 2024. Schedule. June 11-13, 2024. #PosetteConf.
ChistaDATA Inc. retweeted
Clickhouse is doing a lot of interesting stuff, Better optimiser, more Standard SQL, better joins performance!!!
ClickHouse release 24.4!
Join us, live, for a conversation about about the release and time for Q&A.
We are livestreaming at youtube.com/watch?v=dtUqgcfO…
🧵
