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 ...

Let me restart the load. I don't have any statement logging turned on. 
However there is a likelyhood of multiple timestamps.

Joshua D. Drake