Horton

Re: Performance issues with compaq server

Holger Marzen <holger@marzen.de>

View thread View on postgr.es
From: Holger Marzen <holger@marzen.de>
To: Curt Sampson <cjs@cynic.net>
Cc: pgsql-general@postgresql.org, <pgsql-sql@postgresql.org>
Date: 2002-05-09T11:24:12Z
Lists: pgsql-general, pgsql-sql 
On Thu, 9 May 2002, Curt Sampson wrote:

> On Wed, 8 May 2002, Holger Marzen wrote:
>
> > > COPY is even faster as there is less query parsing to be done, plus
> > > you get a transaction per COPY statement even without BEGIN/END.
> >
> > Yes, but I wanted to change something in some rows, so I used perl and
> > insert.
>
> Why not use Perl and COPY?

A good idea. I'll try it if the customer complains about the speed.

-- 
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1