
[MonetDB] create table: time = 0.012353897094726562 s 

[MonetDB] load data : time = 8.45186972618103 s 

size table flights : 13448
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "AIRLINE" = 'AA';
 time = 0.0929955005645752 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights;
 time = 0.3815323352813721 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5;
 time = 0.6225983142852783 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10;
 time = 0.589127492904663 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15;
 time = 0.46872925758361816 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20;
 time = 0.2935174942016602 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25;
 time = 0.1695608139038086 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30;
 time = 0.042101478576660155 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03579902648925781 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.034199857711791994 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03340182304382324 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.0321995735168457 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03259940147399902 s

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03079991340637207 s

[MonetDB] requete (moyenne de 5) : CREATE TABLE flights10 AS SELECT * FROM FLIGHTS WHERE "DAY" > 10;
 time = 1.2161913871765138 s

[MonetDB] requete (moyenne de 5) : DELETE FROM flights WHERE "DAY" > 10;
 time = 0.06782560348510742 s

[MonetDB] requete (moyenne de 5) : INSERT INTO flights SELECT * FROM flights10;
 time = 3.166534423828125 s

[MonetDB] requete (moyenne de 5) : DROP TABLE flights10;
 time = 0.011658573150634765 s

[MonetDB] requete (moyenne de 5) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS;
 time = 5.4091160774230955 s

[MonetDB] requete (moyenne de 5) : UPDATE flights2 SET "WEATHER_DELAY" = -1 WHERE "WEATHER_DELAY" IS NULL;
 time = 0.6946177959442139 s

[MonetDB] requete (moyenne de 5) : DROP TABLE flights2;
 time = 0.004187679290771485 s


[PostgreSQL] create table: time = 0.003996372222900391 s

[PostgreSQL] load data : time = 14.742363214492798 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "AIRLINE" = 'AA'
 time = 0.9537903070449829 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights
 time = 6.442582488059998 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 5
 time = 5.629377007484436 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 10
 time = 4.54988420009613 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 15
 time = 3.520226240158081 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 20
 time = 2.490004539489746 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 25
 time = 1.4594985246658325 s

[PostgreSQL] requete (moyenne de 3) : SELECT * FROM public.flights WHERE "DAY" > 30
 time = 0.4609978993733724 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 5 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.20199966430664062 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 10 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.1969989538192749 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 15 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.19499921798706055 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 20 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.1914997100830078 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 25 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.1829988956451416 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM public.flights WHERE "DAY" > 30 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000 
 time = 0.1809999942779541 s

[PostgreSQL] requete (moyenne de 2) : CREATE TABLE flights10 AS SELECT * FROM FLIGHTS WHERE "DAY" > 10
 time = 6.2952189445495605 s

[PostgreSQL] requete (moyenne de 2) : DELETE FROM flights WHERE "DAY" > 10
 time = 6.375154137611389 s

[PostgreSQL] requete (moyenne de 2) : INSERT INTO flights SELECT * FROM flights10
 time = 7.975377321243286 s

[PostgreSQL] requete (moyenne de 2) : DROP TABLE flights10
 time = 0.040100693702697754 s

[PostgreSQL] requete (moyenne de 2) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS
 time = 10.79914402961731 s

[PostgreSQL] requete (moyenne de 2) : UPDATE flights SET "WEATHER_DELAY" = -1 WHERE "WEATHER_DELAY" IS NULL
 time = 9.842614531517029 s

[PostgreSQL] requete (moyenne de 2) : DROP TABLE flights2
 time = 0.05657327175140381 s
