Past Meetup

Peter Geoghegan on "Query Evaluation Techniques for Large Databases"

This Meetup is past

181 people went

Location image of event venue

Details

***okta has kindly volunteered to host us. They do however ask that you sign an NDA at the door. If this is an issue for you, please let us know in advance.

Mini

Aish Raj Dahal on "Cuckoo Filter: Practically Better Than Bloom" ( https://www.cs.cmu.edu/~dga/papers/cuckoo-conext2014.pdf )

Aish's Bio

Aish (https://twitter.com/aishrajdahal) is a software engineer with a passion for distributed systems. He currently works for PagerDuty, building reliable event driven systems. In the past life, he was at Wall Street building software platforms for high performance trade execution. He was also a maintainer for KDE's KGet project.

Main Talk

Peter Geoghegan on "Query Evaluation Techniques for Large Databases"

Peter tells us: This talk takes some artistic license with the established PWL format. Rather than being a discussion of one particular paper, the talk is intended as a guided tour of the development of various widely implemented relational database join algorithms, with a particular focus on the pressures that shaped their development. Framing the discussion this way is not intended as a history lesson, so much as a vehicle for explaining the practical relevance of each algorithm under discussion, possible future developments, and the fundamental nature of how relational databases implement joins.

That being said, the talk is essentially an exploration of the paper "Query Evaluation Techniques for Large Databases", by Goetz Graefe.

The talk will make quite a few small detours, generally influenced by related papers, but without veering too far from Graefe's central arguments.

Familiarity with working with systems like PostgreSQL, SQL Server, or Oracle will give a good grounding for understanding the material in the talk. Reading over and working through the "Using EXPLAIN" [1] section of the PostgreSQL documentation may be a useful refresher on the topics the talks considers.

[1] https://www.postgresql.org/docs/current/static/using-explain.html

Peter's Bio
Peter (https://twitter.com/petervgeoghegan) has been involved in PostgreSQL development since 2011 as both a reviewer and feature implementer, and is a PostgreSQL Major Contributor.

His development projects tend to be centered on improving PostgreSQL's performance in various ways, including adding support for group commit, as well as a succession of improvements to the PostgreSQL sort code down through the years. Peter is also the primary author of PostgreSQL 9.5's "UPSERT" feature.