On May 29, 2006, at 7:11 AM, Markus Schaber wrote:
One big transaction every 5 minutes using 'COPY FROM' (instead of inserts).Are you using "COPY table FROM '/path/to/file'", having the file sittingon the server, or "COPY table FROM STDIN" or psql "/copy", having the file sitting on the client?
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 +========================================================+ | *---------------- dluke@xxxxxxxxxxxx ----------------* | | *-------------- http://www.geeklair.net -------------* | +========================================================+ | Opinions expressed are mine and do not necessarily | | reflect the opinions of my employer. | +========================================================+
Attachment:
PGP.sig
Description: This is a digitally signed message part
