Joins are slow?
🤔
4 seconds to join 1 million rows to 1 million rows, with Merge Join.
8 seconds with Hash Join.
And if I evilly force the worst plan, 18 seconds with a Nested Loop
(thanks to @Yugabyte Batched Nested Loop 🚀)
"CTO @karthikr said @Yugabyte was the first and only distributed SQL vendor to offer all three PostgreSQL isolation levels, making it that much easier to shift existing applications to a distributed database with advanced support for the default PostgreSQL isolation level." ⬇️
This "rocket" release is packed with goodies, thanks to the efforts of a lot of Yugabeings. Humbled by the team's velocity, focus on quality and obsession with real world use cases 🚀🚀🚀
And it's not only typos... I realize I missed the placement info. @Yugabyte must know the zones to balance leaders and followers correctly. Better like this:
http://141.147.107.216:7000/tablet-servers
(and it is as simple as setting helm values from the @oracleCloud metadata😎)
I've a @Yugabyte DB on @OracleCloud running 100k inserts/sec at ~30ms (1 PK + 1 secondary index), with connections + processing + data distributed over 3 Availability Domains, during a few days to measure the cost. Want to have a look?
http://141.147.107.246:7000/tablet-servers
Great turnout for @karthikr's presentation 'The Biography of a Modern #CloudNative Application,' in the @Yugabyte track at the Silicon Valley @postgresconf earlier. 🚀
And awesome to catch up with people face-to-face again!
Discover more: https://t.co/QaR7fslgJq
Join @Yugabyte experts for the live webinar "When is Eventually (Consistent) Not Soon Enough?" as they look at different database consistency models, the workloads they excel at, and where they may be sub-optimal.
🗓️12 May - 4pm GMT+1🗓️
Register: https://t.co/NhFzKyeHnp
@ryanflorence Can I ask for the reason to move to NoSQL in this context? Without a catalog, optimizer, transaction consistency for any operation, joins, consistent secondary index, aso in the DB, all that, when needed, must be done in the application, yes.
It took ME a long time to know the basics of SQL. Then I met @lukaseder@vlad_mihalcea and realized I didn’t know the basics of SQL. SQL is very powerful, and core to a brave new generation of NewSQL databases like @Yugabyte
https://t.co/oYtXLoC3G4
Hi, Spring fans! In this installment, @starbuxman looks at the brave, bold, and boring @Yugabyte: because when you want to sleep well at night, boring is great
https://t.co/EVd7mFaYUy
It's a wrap for DSS Asia. Lots of learning for our attendees. While we are getting all the sessions to you, you can replay our opening Keynote: The Biography of a Modern Application at https://t.co/dbBQQ3kkpd