forked from stefano/bulk_insert_experiment
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathREADME
34 lines (22 loc) · 730 Bytes
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
To execute these scripts, you need a working PostgreSQL installation.
The following command will drop the database and the user named
'bulk_insert_experiment' (if they exists) and re-create them.
$ sudo -u postgres psql < create_db.sql
Then you need to install the requirements and create the database schema:
$ pip install -r requirements.pip
$ python manage.py migrate
You can now run the benchmark scripts:
$ python orm_create.py
...
$ python orm_bulk_create.py
...
$ python sql_simple_insert.py
...
$ python sql_simple_insert_executemany.py
...
$ python sql_batch_insert.py
...
$ python copy_from.py
...
$ python generate_data_in_database.py
...