Menu
Sign In Search Podcasts Libraries Charts People & Topics Add Podcast API Blog Pricing

Mike Stonebraker

๐Ÿ‘ค Speaker
444 total appearances

Appearances Over Time

Podcast Appearances

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And so a stream processing engine looks nothing like a relational database.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And we had the gist of an idea for column stores for data warehouses, which was popularized by Vertica.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

looks nothing like a row store.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

So here were three wildly different implementations that had no resemblance to each other.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And in each case, they were an order of magnitude faster than the other guys.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

So it's pretty clear that with those three instances, you give up an order of magnitude when you're running a database system that isn't

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

that isn't architected for your kind of stuff.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

I think that's still true.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

I mean, I think ClickHouse is a column store.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

Pinecone is faster than user-defined types on text-based vector processing.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And so I think it's still very much the case.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And I think there's no difficulty putting a common parser on top of multiple implementations.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

Postgres has so far chosen not to do that.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

They don't implement a column store.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

And so I think they are not competitive on sizable data warehouses.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

They also don't have multi-node support, again, for people with big data warehouses.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

That's table stakes.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

So I think it's just as true today as it ever was.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

I think that what is true is that if you want to get going, you have a database problem.

The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker

The answer is choose Postgres.