Abbas Mashayekh

During my years of experience implementing various complex software projects, I have developed a deep understanding of the inner workings of PostgreSQL. I am particularly skilled in query performance optimization, having spent countless hours studying the intricacies of the PostgreSQL query planner and optimizer. In addition, I have explored many of PostgreSQL's advanced features, such as partitioning, indexing, and parallel query execution, and have learned how to leverage these features to improve performance even further. What sets me apart from many other PostgreSQL users is my willingness to dive deep into the system's internals. I have spent a significant amount of time reading PostgreSQL source code, which has given me an even greater understanding of how the system works. This has enabled me to optimize queries in ways that would not be possible without a detailed understanding of the underlying system. I also have deep understanding of PostgreSQL's query parser as well as its binary wire protocol, and have implemented a wire-level proxy that has the ability to continue processing queries even if a particular PostgreSQL backend dies, by quickly switching to a different backend.

I have read many of the various extensions and proposals in this domain, and helped with implementation of some in a compiler optimizer project called Binaryen. Binaryen is used by many Wasm tools to optimize the compiled WebAssembly file. My direct experience with WebAssembly is related to a personal project in which I wanted to replicate an old computer game in a browser using WebGL 2.0, and I used Rust code compiled to WebAssembly to read game data files, decode graphical resources and load everything in WebGL buffers. Although I didn't finish the game, but the results were exciting to me!