Re: 8.3 / 8.2.6 restore comparison

"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 ...
        regards, tom lane