Re: 8.3 / 8.2.6 restore comparison

Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> 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