apavlo

9 ms·

31.
by apavlo 2y ago
> Wow, the reasons why Redis commands API suck in Andy's video (linked in the post) are the weakest ever. In my example, the API on a key changes based on its value type. And the same collection can have different value types mixed
32.
by apavlo 2y ago
Instead of emailing me to ask if you can translate my end-of-year blog article to Chinese like you did last year, this year you decided to just copy my format? I will be sure to mention that when I release mine next week.
33.
by apavlo 2y ago
If all table pages exist in memory and you are using cooperative GC, then O2N can be preferable. As workers scan version chains, they can clean up dead tuples without taking additional locks. This is what Microsoft Hekaton does.
34.
by apavlo 2y ago
> EloqKV brings significant innovations to database design What is the novel part? I read your "Introduction to Data Substrate" blog article and the architecture you are describing sounds like NuoDB from the early 2010s. The on
35.
by apavlo 2y ago
This is from me. I didn't realize the connection to Lutris + Enhydra. It should be listed as a "Acquired Company" + "Abandoned Project". Wikipedia also says that it lasted until 2001. Usage is different from develop
36.
by apavlo 2y ago
> Can you try to use a memory-mapped file Definitely do *not* use MMAP for this.
37.
by apavlo 2y ago
You want our Intro DB Systems course not the Advanced one: https://15445.courses.cs.cmu.edu Lectures start next month. Or you can watch previous years. Learn to walk before you run.
38.
CedarDB: German-Powered, PostgreSQL-Compatiable Freak of Nature Database System(cedardb.com)
29 points by apavlo 2y ago|4 comments
39.
by apavlo 2y ago
CedarDB is the commercial version of the impressive Umbra database system from TU Munich.
40.
by apavlo 2y ago
Lance v2 looks interesting. I like their meta-data + container story. Lacking SOTA encoding schemes though. There is also Vortex ( https://github.com/fulcrum-so/vortex ). That has modern encoding schemes that we want to
41.
by apavlo 2y ago
> Have a situation right now where I am bottlenecked by IO and not compute. Can you describe your use-case? Are you reading from NVMe or S3?
42.
by apavlo 3y ago
> it seemed like it might be genuine It is genuine. Larry and I go way back. Source: https://youtu.be/_UGUDVeSQSI?t=872
43.
by apavlo 3y ago
> just wanted to mention that I found bidirectional linear probing to outperform Robin Hood across the board in my Java integer set benchmarks Research results from the last five years shows that Robin Hood hashing performs better than t
44.
by apavlo 3y ago
> No, you don't. This is correct. Most disk-oriented DBMSs use fixed-size pages. So you can't go larger than the node size (not entirely true if using auxiliary data structures to buffer changes like an inefficient -epsilon tre
45.
by apavlo 3y ago
No. I've been meaning to do an updated article but I've been unfortunately too busy. A bunch of companies send us shirts to give out to students: * https://twitter.com/andy_pavlo/status/165901903581872947
46.
by apavlo 3y ago
Where can I find an SVG version of this logo? https://github.com/chdb-io/chdb/raw/main/docs/_static/snake-...
47.
by apavlo 3y ago
Do you have a logo? 200 lines is a bit misleading since RocksDB is doing all the heavy lifting.
48.
by apavlo 3y ago
I am going to guess Helium?
49.
by apavlo 3y ago
Why would any company take the risk on adopting a single-person passion project DBMS that is leftover from failed startup? The best you can hope for is to make a logo, slap it on Github, and then I'll add it to my list: https:/&#
50.
by apavlo 3y ago
I will fix. Thank you.
51.
by apavlo 3y ago
This is me. I only care about databases. What was your system?
52.
by apavlo 3y ago
> I wonder why they chose such an unrepresentative dataset size, ~84MB. Yo. This is me. The point of this paper was to evaluate the core MVCC algorithms under different contention scenarios. So you strip out all the internal features of
53.
by apavlo 3y ago
> I had a feeling this was OtterTune's product through a reading of the abstract before I noticed the names. No, this project is separate from OtterTune. I keep our CMU research strictly firewalled from OtterTune for legal reasons.
54.
by apavlo 3y ago
See our 2014 paper on evaluating CC protocols on in-memory system with high contention / core counts: https://www.vldb.org/pvldb/vol8/p209-yu.pdf All the protocols regress to the same. This evaluation was onl
55.
by apavlo 3y ago
LingoDB is an interesting system. Jana has done great work with it. I like projects that take unorthodox approaches to old problems. The problem with (most) query optimizers is that they take a one shot approach at optimization. I think an
56.
by apavlo 3y ago
Yikes! Thanks for the heads up. Peter left Stanford so I guess they took over the domain name :-(
57.
by apavlo 3y ago
Actually, it was a combination of three things: 1. OtterTune Start-up ( https://ottertune.com ) 2. Biological Daughter ( https://twitter.com/andy_pavlo/status/1187841279260004355 ) 3. Pandemic When the pan
58.
by apavlo 3y ago
> Database engines are the last place you want to be playing in traffic if you are going to be on the hook for support. This is a great line! I'm going to steal it if that's okay with you.
59.
by apavlo 3y ago
Watch my course lectures from last semester: https://15721.courses.cs.cmu.edu/spring2023/
60.
by apavlo 3y ago
I have no idea what it's supposed to say. I think I just put "Andy Pavlopolis" into Google Translate. It's meant to be a joke. Before I started at CMU, all of the database professors in the city of Pittsburgh (Carnegie M

More ›