Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Andy Pavlo (@andypavlo.bsky.social) Profile picture
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Associate Professor of Databases @CarnegieMellon.
Dec 18, 2023 • 4 tweets • 3 min read
Are you running #PgBouncer? Are you disappointed that it is slow + unscalable? @butro's latest VLDB paper shows how to use #eBPF to accelerate this popular PostgreSQL proxy by running on kernel threads.
➡️Paper:
➡️Code: vldb.org/pvldb/vol16/p3…
github.com/mbutrovich/tig…
Tigger's User-Bypass Architecture using eBPF .@butro's PhD thesis is on user-bypass methods to embed DBMS logic into the kernel with eBPF. PgBouncer does auth but then connection pooling + forwarding happens in kernel. Tigger removes copying data from kernel to app. It also gets multi-threading for free using kthreads. User-Space Proxy vs. User-Bypass Proxy Implementations
May 9, 2022 • 6 tweets • 5 min read
Vaccination DB Talk Booster #12: @majetideepak lays out the architecture of Velox:

Velox is a C++ vectorized execution engine to replace @prestodb's Java-based engine. It is being developed by @AhanaIO + Facebook + others. Velox is not a full DBMS: it doesn't have a SQL parser, catalog, optimizer, networking, etc. It's an extensible execution engine + buffer pool + storage connectors. It internally uses @ApacheArrow columnar format, but not the rest of the Arrow engine. ImageImage
Dec 29, 2020 • 13 tweets • 5 min read
If you're interested in DB internals, stop what you're doing and watch @CMUDB Quarantine Talk from Nico+Cesar about @SQLServer's Cascades query optimizer:

Many talks this semester were good. This one is the best. My thread provides key takeaways [6:50] Microsoft hired Goetz Graffe in the 1990s to help them rewrite original Sybase optimizer into Cascades. This framework is now used across all MSFT DB products (@SQLServer, @cosmosdb, @Azure_Synapse).
Oct 24, 2018 • 9 tweets • 4 min read
So I was slightly involved with this story:

TLDR: I've read the internal Amazon document in the CNBC story. @Werner is correct. When I told the reporter that it wasn't a big deal he called me on the phone and flipped out. Two weeks ago this reporter reached out to the top DB profs (@joe_hellerstein, @franklinmj, @pateljm) + junior people like me asking for help with a story about Amazon Aurora. His original email said that he was looking for helping on understanding database terms.