Hi Brian,
Thank you for your reply.
I have put all the details down. I realise that there is something I am doing wrong. Can you please guide me to that.
apakau@apakau:~$ monetdbd --version
MonetDB Database Server v1.7 (Jul2015-SP1)
apakau@apakau:~$ monetdb --version
MonetDB Database Server Toolkit v1.1 (Jul2015-SP1)
apakau@apakau:~$ mclient --version
mclient, the MonetDB interactive terminal (Jul2015-SP1)
support for command-line editing compiled-in
character encoding: UTF-8
The table on which we are doing the insertion is as follows :
CREATE TABLE "apakau"."rec" (
"id" BIGINT NOT NULL DEFAULT next value for "apakau"."seq_7069",
"dom_id" VARCHAR(128) NOT NULL,
"api_d" VARCHAR(128) NOT NULL,
"end_ip" VARCHAR(128),
"time_s" TIMESTAMP NOT NULL,
"d_time_m" TIMESTAMP NOT NULL,
"cntry" VARCHAR(2) NOT NULL,
"cntry_state" VARCHAR(16),
"city" VARCHAR(32),
"is_vpn_proxy" BOOLEAN,
"kbtoep" INTEGER,
"calls_r" INTEGER,
"calls_w" INTEGER,
"avg_latency" INTEGER,
"cache_hit_count" INTEGER,
"retries" INTEGER,
"error_msg" VARCHAR(256),
"blocked_by_rate" INTEGER,
"blocked_by_geo" INTEGER,
"sec_grade" INTEGER,
"sec_grade_count" INTEGER,
CONSTRAINT "rec_id_pkey" PRIMARY KEY ("id")
);
CREATE INDEX "rec_cload1" ON "apakau"."rec" ("dom_id", "end_ip", "time_s", "calls_r", "calls_w", "id");
CREATE INDEX "rec_id" ON "apakau"."rec" ("id");
CREATE INDEX "rec_tgeo1" ON "apakau"."rec" ("dom_id", "cntry", "cntry_state", "api_d", "d_time_m", "id");
We are using ubuntu15.0. Our machine has
apakau@apakau:~$ lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 4
On-line CPU(s) list: 0-3
Thread(s) per core: 1
Core(s) per socket: 4
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 60
Model name: Intel(R) Core(TM) i5-4460 CPU @ 3.20GHz
Stepping: 3
CPU MHz: 800.000
CPU max MHz: 3400.0000
CPU min MHz: 800.0000
BogoMIPS: 6385.52
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 6144K
NUMA node0 CPU(s): 0-3
apakau@apakau:~$ cat /proc/meminfo
MemTotal: 3922352 kB
MemFree: 481064 kB
MemAvailable: 1955012 kB
Buffers: 198488 kB
Cached: 1343160 kB
SwapCached: 8392 kB
Active: 2619384 kB
Inactive: 639576 kB
Active(anon): 1663028 kB
Inactive(anon): 187248 kB
Active(file): 956356 kB
Inactive(file): 452328 kB
Unevictable: 32 kB
Mlocked: 32 kB
SwapTotal: 4069372 kB
SwapFree: 3988984 kB
Dirty: 40 kB
Writeback: 0 kB
AnonPages: 1710392 kB
Mapped: 245924 kB
Shmem: 132968 kB
Slab: 121080 kB
SReclaimable: 94520 kB
SUnreclaim: 26560 kB
KernelStack: 5984 kB
PageTables: 20288 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 6030548 kB
Committed_AS: 3821748 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 356028 kB
VmallocChunk: 34358947836 kB
HardwareCorrupted: 0 kB
AnonHugePages: 1255424 kB
CmaTotal: 0 kB
CmaFree: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 115088 kB
DirectMap2M: 2906112 kB
DirectMap1G: 1048576 kB
Regards,
Poornima.
----- Original Message -----
From: "Brian Hood"