> Rod Taylor <[EMAIL PROTECTED]> writes:
>> Do you happen to have any numbers comparing prepared inserts in a single
>> transaction against copy?
> COPY is about a factor of 6 faster, it appears. I got 11.8 versus
> 1.87 seconds for loading the same amount of data (with the 3-column
> test table)
Rod Taylor <[EMAIL PROTECTED]> writes:
> Do you happen to have any numbers comparing prepared inserts in a single
> transaction against copy?
COPY is about a factor of 6 faster, it appears. I got 11.8 versus
1.87 seconds for loading the same amount of data (with the 3-column
test table). So COPY
On Tue, 2003-08-12 at 15:36, Tom Lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > I wasn't interested in measuring the performance of yacc -- since I know
> > it is bad. It was a basic test which wasn't even meant to be real
> > world. It just seemed interesting that the numbers were thre