Created
March 31, 2014 08:23
-
-
Save eric-pommereau/9887701 to your computer and use it in GitHub Desktop.
Postgresql : DataFiller
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE usr ( | |
usr_id integer UNIQUE NOT NULL, | |
usr_ni UNIQUE VARCHAR(20) NOT NULL, | |
usr_code_unite VARCHAR(20) NOT NULL, | |
usr_institution CHAR(2) UNIQUE NOT NULL, --df: word=:PN,GN | |
usr_dthr_create timestamp with time zone NOT NULL, | |
usr_dthr_update time without time zone DEFAULT now() NOT NULL, | |
usr_cn VARCHAR(100) NOT NULL, | |
usr_dept_uid text NOT NULL | |
); | |
postgres@stc075sc008273:~$ ./datafiller -s 10000 user.sql |psql -p 5432 idic | |
Chronométrage activé. | |
L'affichage étendu est utilisé automatiquement. | |
# filling table usr (10000) | |
Temps : 2167,409 ms | |
ANALYZE | |
Temps : 641,271 ms | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment