Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
opreport -l /usr/bin/postgres
CPU: AMD64 processors, speed 2411.14 MHz (estimated)
Counted CPU_CLK_UNHALTED events (Cycles outside of halt state) with a
unit mask of 0x00 (No unit mask) count 100000
samples % symbol name
47654 15.5165 DoCopy
36231 11.7971 CopyReadLine
25046 8.1551 heap_formtuple
24137 7.8592 XLogInsert
13829 4.5028 InputFunctionCall
9618 3.1317 ParseDateTime
9521 3.1001 DecodeDateTime
9446 3.0757 pg_next_dst_boundary
7651 2.4912 DecodeDate
6948 2.2623 AllocSetAlloc
6290 2.0481 ExecConstraints
5462 1.7785 DecodeNumber
3287 1.0703 pg_atoi
Hmm, so what's the declaration of the table you're copying into?
Obviously there's some datetime column(s) in it ...
Ahh nevermind.. stopping the load gave me the table:
Column | Type | Modifiers
-----------------------+-----------------------------+--------------------
unit_id | integer | not null
lead_id | integer | not null
timehit | timestamp with time zone | not null
followuptime | timestamp with time zone | not null
message | integer | not null default 0
email | character varying(50) | not null
stop_status | integer | not null
stop_time | timestamp with time zone |
note | character varying(20) |
name | character varying(60) |
name2 | character varying(60) |
add_method | integer |
verified | integer |
verification_notes | character varying(100) |
add_notes | character varying(100) |
datum1 | character varying(100) |
datum2 | character varying(100) |
datum3 | character varying(100) |
datum4 | character varying(100) |
datum5 | character varying(100) |
datum6 | character varying(100) |
datum7 | character varying(100) |
datum8 | character varying(100) |
datum9 | character varying(100) |
datum10 | character varying(100) |
datum11 | character varying(100) |
datum12 | character varying(100) |
datum13 | character varying(100) |
datum14 | character varying(100) |
datum15 | character varying(100) |
datum16 | character varying(100) |
datum17 | character varying(100) |
datum18 | character varying(100) |
datum19 | character varying(100) |
datum20 | character varying(100) |
datum21 | character varying(100) |
datum22 | character varying(100) |
datum23 | character varying(100) |
datum24 | character varying(100) |
datum25 | character varying(100) |
stop_method | integer |
add_url | character varying(100) |
verification_time | timestamp without time zone |
geog_data_last_update | timestamp without time zone |
geog_country | character varying(100) |
geog_region | character varying(100) |
geog_city | character varying(100) |
geog_postal | character varying(100) |
geog_lat | double precision |
geog_lon | double precision |
geog_dma_code | integer |
geog_area_code | integer |
geog_isp | character varying(100) |
geog_org | character varying(100) |
file_upload_id | integer |
I have 100 of these tables (identical).
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
