Re: 8.3 / 8.2.6 restore comparison

Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.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
timezone    | 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                |
charactervarying(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               |
charactervarying(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               |
charactervarying(100)      | verification_time     | timestamp without time zone | geog_data_last_update | timestamp
withouttime 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