<  *  | *** >

Taxi benchmark 

  • data model
  • pre requisite
  • download data
  • insert data
  • full load

Taxi benchmark

data model

pre requisite

You will need around 250 GB of RAM for the full dataset
Disable swap
swapoff -a
Disable THP (=Transparent Huge Page) if activated
On Centos (as root)
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
On Redhat (as root)
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
echo never > /sys/kernel/mm/redhat_transparent_hugepage/defrag

download data

Https://www.stormbase.fr/downloads/taxi_small.zip

insert data

full load