PG_BULKLOAD data loading issue with index

[pintul83]

Hi,
I am facing the below issue on pg_bulkloader.
for better understanding...
I created the below table with index and then loaded data, as the log file shows everything is success but i don't find that amount of record on the loaded table.

see the below exact commands...

CREATE TABLE  quovaadm.SATYA_GEOIP
(
     START_IP_INT            bigint,
     END_IP_INT              bigint,
     CIDR                    integer,
     CONTINENT               character varying(128),
     COUNTRY                 character varying(128),
     COUNTRY_ISO2            character varying(2),
     COUNTRY_CF              integer,
     REGION                  character varying(128),
     STATE                   character varying(128),
     STATE_CF                integer,
     CITY                    character varying(128),
     CITY_CF                 integer,
     POSTAL_CODE             character varying(128),
     PHONE_NUMBER_PREFIX     character varying(64),
     TIMEZONE                numeric(5,2),
     LATITUDE                numeric(12,6),
     LONGITUDE               numeric(12,6),
     DMA                     integer,
     MSA                     character varying(10),
     PMSA                    integer,
     CONNECTIONTYPE          character varying(32),
     LINESPEED               character varying(32),
     IP_ROUTINGTYPE          character varying(32),
     AOL                     character varying(1),
     ASN                     integer,
     SLD_ID                  integer,
     TLD_ID                  integer,
     REG_ORG_ID              integer,
     CARRIER_ID              integer
);
 
 
 
create index satya_idx_quova on quovaadm.SATYA_GEOIP (country_iso2);
 
 
 
dw_dev1=# SELECT pg_bulkload(ARRAY['TABLE=quovaadm.SATYA_GEOIP','INFILE=/transfer/inbound/geoip/quova/geoip_data.dat','TYPE=CSV','DELIMITER=|','LOGFILE=/transfer/inbound/geoip/quova/satya_quova.log','PARSE_BADFILE=/transfer/inbound/geoip/quova/satya_quova.bad','PARSE_ERRORS=999999','DUPLICATE_ERRORS=999999','ON_DUPLICATE_KEEP=OLD','WRITER=BUFFERED','MULTI_PROCESS=YES']);
 

pg_bulkload
---------------------------------------------------
(0,11614864,0,0,0,1.640751,154.681485,203.964952)
(1 row)

dw_dev1=# select count(1) from quovaadm.SATYA_GEOIP;
count
---------
8048890
(1 row)

[Rabbit]

What amount of records are you expecting to see?

[pintul83]

As the log shows 11614864 records loaded.

So count of the records in table should be 11614864.