Master Thesis' repository to test PostgreSQL capabilities on varying data ingestion size (12/2020)
Tester of the Postgresql ability of ingesting time series data, from 1 to N tuples at a time
build/
, containing the generated .class files after compiling the java code;data/
, containing the printers parsed logs files in the format of CSV files;logs/
, containing the log information of all the tests done;resources/
, containing the postgresql driver, the database credentials file and the logger properties;src/
, containing the java source files;standalone/
, containing the JAR standalone version of this repository.In the main directory, there is:
compile_and_run.bash
, a bash file containing the commands for compiling the java code and running it.build
;data
;resources
,server_postgresql_credentials.txt
, containing the username (first line) and the password (second line) to access the server PostgreSQL database;postgresql-42.2.14.jar
);bash compile_and_run.bash
Since I couldn’t manage to find a way with the command line, I used Eclipse:
Window > Preferences > Java > Installed JREs
;Apply and Close
;Window > Preferences > Java > Compiler
;1.8
;Apply and Close
;Export
;Java > Runnable JAR file > Next
;Main
;test_postgresql_n_data_ingestion/standalone/NDataIngestionTest.jar
;Finish
.java -jar standalone/NDataIngestionTest.jar
.ssh -t sfracalossi@ironlady.inf.unibz.it "cd /data/sfracalossi ; bash"
;mkdir postgresql
;mkdir postgresql/standalone_n_ingestion
;mkdir postgresql/standalone_n_ingestion/resources
;mkdir postgresql/standalone_n_ingestion/data
;scp standalone/NDataIngestionTest.jar sfracalossi@ironlady.inf.unibz.it:/data/sfracalossi/postgresql/standalone_n_ingestion
;scp resources/server_postgresql_credentials.txt sfracalossi@ironlady.inf.unibz.it:/data/sfracalossi/postgresql/standalone_n_ingestion/resources
;scp resources/logging.properties sfracalossi@ironlady.inf.unibz.it:/data/sfracalossi/postgresql/standalone_n_ingestion/resources
;scp data/TEMPERATURE.csv sfracalossi@ironlady.inf.unibz.it:/data/sfracalossi/postgresql/standalone_n_ingestion/data
;cd postgresql/standalone_n_ingestion
;nohup java -jar NDataIngestionTest.jar [M] [N] [l/s] [file_name_in_data_folder] > logs/out.txt &
.