Re: [PERFORM] Getting even more insert performance (250m+rows/day)

[Daniel J. Luke]

On May 29, 2006, at 7:11 AM, Markus Schaber wrote:

One big transaction every 5 minutes using 'COPY FROM' (instead of
inserts).

on the server, or "COPY table FROM STDIN" or psql "/copy", having the
file sitting on the client?

Are you using "COPY table FROM '/path/to/file'", having the file sitting

COPY table FROM STDIN using psql on the server

I should have gprof numbers on a similarly set up test machine soon ...
--
Daniel J. Luke
+========================================================+
| *---------------- [EMAIL PROTECTED] ----------------* |
| *-------------- http://www.geeklair.net -------------* |
+========================================================+
|   Opinions expressed are mine and do not necessarily   |
|          reflect the opinions of my employer.          |
+========================================================+

PGP.sig
Description: This is a digitally signed message part