Skip to content

tobbik/testpginsert

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Test Postgres DB insert Speed

Reason

Trying to compare Postgres driver performance in different languages/frameworks. It tries to insert am vcertain amount of values into th database, utilizing and requiring foreign key constraints, which requires to read results back befor more inserting can be done.

Setup

It requires a docker Setup to install a postgres DB or you provide your own connectionstring.

  • run reset_db.sh to reinstall docker instance and start and wipe DB

Then run 'make setup' which does the following steps:

  • setup the nodejs environments (npm install)
  • setup the python virtualenv and downloads the needed packages (pip3 install)
  • be aware that the numpy install takes a long time (~10min) depending on your machine
  • create the common dictionary for the phrase generator

Run

  • in the psychopg directory activate the virtualenv and 'make run'
  • in node-* directries just run make run

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published