This repository contains the experiment scripts, evaluation notebooks and links to the datasets that are used in our SIGMOD 2025 publication "An Elephant Under the Microscope: Analyzing the Interaction of Optimizer Components in PostgreSQL" (DOI 10.1145/3709659).
On a high level, the repository is structured as follows:
| Folder | Description |
|---|---|
datasets/ |
Contains references to the actual datasets. All datasets are open access and archived in the OPARA repository. |
evaluation/ |
Contains various Jupyter notebooks that generate the plots used throughout the paper as well as calculations that determine other key numbers. |
experiments/ |
Contains the Python scripts that compute the datasets. These scripts can be used to reproduce our results. See Reproducibility for details. |
pg_lab/ |
Links to the pg_lab repository that is used to interact with a PostgreSQL instance in our paper. The submodule is checked out at the latest state that was used for publication. |
postbound/ |
Links to the PostBOUND respository that is used for optimizer hinting, plan analysis, etc. in our paper. The submodule is checked out at the latests state that was used for publication. |
Please note that both pg_lab as well as PostBOUND are frameworks under active development. If you are interested in using them for your own experiments, we kindly ask you to use the latest versions available on Github. Both have been much improved since their original publication.
TBD