| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | Curt Sampson <cjs(at)cynic(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Performance issues with compaq server |
| Date: | 2002-05-09 11:24:12 |
| Message-ID: | Pine.LNX.4.44.0205091323390.4909-100000@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gray | 2002-05-09 11:43:33 | Re: Performance issues with compaq server |
| Previous Message | Holger Marzen | 2002-05-09 11:23:17 | Re: Performance issues with compaq server |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gray | 2002-05-09 11:43:33 | Re: Performance issues with compaq server |
| Previous Message | Holger Marzen | 2002-05-09 11:23:17 | Re: Performance issues with compaq server |