This repository is a fork of the project. Here we unite queries and data in one place. Main goal of this repository is simplifying of the deploy process.
Large tables divided into chunks each less than 100 MB.
Repository contains some scripts for quick deploy & run of the benchmark:
- schema.sql - creates the data schema.
- copy.sql - copies data from csv files into the tables. Uses
datadirvariable to make absolute paths to csv files. Usepsql -vto define it. - parts.sql - script which splitted the tables. Just for future reusage.
- job - a template script for quick launch of the benchmark.
Example below shows export procedure of all tables:
psql -f ~/jo-bench/schema.sql
psql -vdatadir="'/home/user/jo-bench'" -f ~/jo-bench/copy.sql
NB! Deploying tested on database with C-locale.