Re: [HACKERS] Parsing speed (was Re: pgstats_initstats() cost)

2003-08-14 Thread Tom Lane
> 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)

Re: [HACKERS] Parsing speed (was Re: pgstats_initstats() cost)

2003-08-14 Thread Tom Lane
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

Re: [HACKERS] Parsing speed (was Re: pgstats_initstats() cost)

2003-08-14 Thread Rod Taylor
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