| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Holger Marzen <holger(at)marzen(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Performance issues with compaq server |
| Date: | 2002-05-09 07:11:59 |
| Message-ID: | Pine.NEB.4.43.0205091611370.454-100000@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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?
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2002-05-09 11:23:17 | Re: Performance issues with compaq server |
| Previous Message | Nitin R Kudalkar | 2002-05-09 06:10:27 | two postgres server connection |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriel Dovalo Carril | 2002-05-09 10:12:59 | Can this query be faster? |
| Previous Message | jade | 2002-05-09 06:18:17 | Re: [SQL] postgresql 7.1 file descriptor |