erichosick

First Setup (command Line):

mkdir mech
cd mech
npm install mech-core
npm install mech-scope-cell
npm install mech-math
npm install mech-emit
node

erichosick

// see https://github.com/CollectionFS/Meteor-cfs-s3
// see http://help.modulus.io/customer/portal/articles/1653448-file-storage
//   - /app-storage/tmp vs /mnt/data/tmp ? app-storage is permanent
FS.debug = true;
FS.HTTP.setBaseUrl('/media');
FS.HTTP.setHeadersForGet([
	['Cache-Control', 'public, max-age=31536000']
]);

var settings = {};

erichosick

// The root of the configuraton file is scoped to the
//  entire company: all software offerings.
{
  // The Platform context contains all services and
  //  applications for a specific product offering.
  "platform": {
    // The Compute context provides configuration 
    // to a specific application, service, mciro-service,
    // lambda, etc.
    "compute": {

erichosick

-- You must run the benchmark schema localed in 
-- https://gist.github.com/erichosick/eeadc41e33ea2a91bd136b9433e73dc7
-- before running the following benchmark

DO $$
DECLARE d_exec_count int = 20;
DECLARE d_left_sql text;
DECLARE d_right_sql text;
BEGIN

erichosick

-- You must run the benchmark schema localed in 
-- https://gist.github.com/erichosick/eeadc41e33ea2a91bd136b9433e73dc7
-- before running the following benchmark

DO $$
DECLARE d_exec_count int = 20;
DECLARE d_left_sql text;
DECLARE d_right_sql text;
DECLARE d_up_sql text;
DECLARE d_down_sql text;

erichosick

-- You must run the benchmark schema localed in 
-- https://gist.github.com/erichosick/eeadc41e33ea2a91bd136b9433e73dc7
-- before running the following benchmark

DO $$
DECLARE d_exec_count int = 20;
DECLARE d_left_sql text;
DECLARE d_right_sql text;
DECLARE d_up_sql text;
DECLARE d_down_sql text;

erichosick

-- EXTENSIONS ------------------------------------------------------------------

-- Supports uuid type and generating uuid
-- https://www.postgresql.org/docs/current/uuid-ossp.html
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

-- Supports  cryptographic functions
-- https://www.postgresql.org/docs/current/pgcrypto.html
CREATE EXTENSION IF NOT EXISTS "pgcrypto"; 

erichosick

-- You must run the benchmark schema localed in 
-- https://gist.github.com/erichosick/eeadc41e33ea2a91bd136b9433e73dc7
-- before running the following benchmark

DO $$
DECLARE d_exec_count int = 20;
DECLARE d_row_count int = 3e6;
BEGIN

  CALL benchmark.execute(