By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,406 Members | 2,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,406 IT Pros & Developers. It's quick & easy.

PG_BULKLOAD data loading issue with index

P: 2
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...

Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE  quovaadm.SATYA_GEOIP
  2. (
  3.      START_IP_INT            bigint,
  4.      END_IP_INT              bigint,
  5.      CIDR                    integer,
  6.      CONTINENT               character varying(128),
  7.      COUNTRY                 character varying(128),
  8.      COUNTRY_ISO2            character varying(2),
  9.      COUNTRY_CF              integer,
  10.      REGION                  character varying(128),
  11.      STATE                   character varying(128),
  12.      STATE_CF                integer,
  13.      CITY                    character varying(128),
  14.      CITY_CF                 integer,
  15.      POSTAL_CODE             character varying(128),
  16.      PHONE_NUMBER_PREFIX     character varying(64),
  17.      TIMEZONE                numeric(5,2),
  18.      LATITUDE                numeric(12,6),
  19.      LONGITUDE               numeric(12,6),
  20.      DMA                     integer,
  21.      MSA                     character varying(10),
  22.      PMSA                    integer,
  23.      CONNECTIONTYPE          character varying(32),
  24.      LINESPEED               character varying(32),
  25.      IP_ROUTINGTYPE          character varying(32),
  26.      AOL                     character varying(1),
  27.      ASN                     integer,
  28.      SLD_ID                  integer,
  29.      TLD_ID                  integer,
  30.      REG_ORG_ID              integer,
  31.      CARRIER_ID              integer
  32. );
  33.  
  34.  
  35.  
  36. create index satya_idx_quova on quovaadm.SATYA_GEOIP (country_iso2);
  37.  
  38.  
  39.  
  40. 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']);
  41.  
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)
Dec 21 '12 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,366
What amount of records are you expecting to see?
Dec 21 '12 #2

P: 2
As the log shows 11614864 records loaded.

So count of the records in table should be 11614864.
Dec 24 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.